The Do’s and Don’ts of PowerPivot – Excel 2016 and SharePoint 2013

When you do development for many years in one platform it gives you the chance to learn a thing or two about all the different limitations across all its different versions. The same rule applies to SharePoint. Recently our team had to develop in a SharePoint 2013 environment using PowerPivot on a SQL Server 2012 environment.  For about three months our work was going well, until we went from Office 2013 to Office 2016.  Several PowerPivot files began to get an error “Call to Excel Services Returned Error” during their scheduled refresh.  If we opened the file in Excel 2016 and refreshed the file, it refreshed with no issue. Our team got a hold of the ULS logs and while…