#ProjectServer 2010 #Excel Services Reports fail to Refresh #Office2013 #SP2010
   I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article) |
A quick post to highlight an issue you may face if you have upgraded to Office / Excel 2013. I recently created some Excel reports for Project Server 2010 using Excel 2013. These reports failed to refresh in Excel Services. After a quick check on the connection string in Excel, the provider is MSOLAP.5 rather than the usual MSOLAP.4 provider when using Excel 2010. See below
Excel 2010:
Excel 2013:
The ULS log error is:
The workbook ‘http://vm730:81/pwa/ProjectBICenter/Reports/Actual Work.xlsx’ attempted to access external data using the unsupported provider ‘Provider=MSOLAP.5
The fix is very simple, navigate to Central Admin > Manager Service Applications > Excel Services > Trusted Data Providers then add the MSOLAP.5 provider as below:
SharePoint (and Project Server) Shenanigans 