Powerpivot and the Unattended Service Account

My customer had a tough time understanding how the Unattended Service account relates to the actual PowerPivot workbooks. This specific scenario was Powerpivot 2012 and SharePoint 2013. Quick shout out to my colleague Rick Andring for all the help he provided in helping my customer understand all of this stuff. His teams’ blog can be…


SharePoint 2013 and PowerPivot 2012: why are there so many data model databases?

Problem: My customer sent me a screenshot of their SQL Server Management studio Analysis Services database listing. They were concerned with one of the database model tables appearing multiple times, in this case around 20 times. They asked me how can they determine which of these copies is the one that is active? Just so…


PowerPivot 2008 R2 and SharePoint 2010: We cannot locate a server to load the workbook Data Model

Problem: Customer was experiencing the error below when trying to view a PowerPivot workbook in their SharePoint site. This was only occurring in their production farm. I also found this error in the logs: Troubleshooting: verified they had the SQL Server analysis service instance enabled on the PowerPivot/SharePoint server (problem still occurred) verified that their…

1

PowerPivot for SharePoint: Failed to render chart

Problem: on a SharePoint 2010/PowerPivot 2008 R2 environment, users would receive a 'Failed to render' chart' error Troubleshooting: Based on previous experience I tried the following but all came back negative Is PowerPivot feature enabled at the site collection? Yes Recycled app pools – error still occurs Verified that CT2WTS is enabled on every server running…