Correcting Impersonated Custom Identity in SharePoint Designer

Recently, I have done a lot of work with SharePoint Designer 2013 and External Content Types (ECT).  In a previous blog, SharePoint Online to Azure SQL Database: Part 1, I covered how to work with ECTs.  Since, writing that blog, I ran into an unexpected issue that caught me by surprise.  I was adding a data source for my ECTs in a new environment and made a mistake when entering the credentials for the Secure Store Application ID.  This blog is not meant to be long or mind blowing.  It is meant to save you some time.  The following is what to do if you enter the wrong credentials for the Secure Store Application ID in SharePoint Designer 2013. What…

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…