KNOWLEDGE BASE

Error "An error occurred while communicating with Microsoft PowerPivot .. side-by-side configuration is incorrect"


Published: 06 Aug 2013
Last Modified Date: 03 Nov 2015

Issue

When connecting to PowerPivot using a SharePoint URL, the following error might occur:

An error occurred while communicating with Microsoft PowerPivot.
The connection to the data source might have been lost.

Analysis Services database error 0x80004005: The following system error occurred: The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log or use the command-line sxstrace.exe tool for more details.
 
Analysis Services database error 0x80004005: The following system error occurred:
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

Environment

  • Tableau Desktop
  • Windows 7
  • Powerpivot

Resolution

Use the following troubleshooting steps to resolve this issue:
  • Ensure the PowerPivot web.config file has the same authentication scheme as the web application in IIS. 
  • Verify that SharePoint has PowerPivot functionality enabled.
  • Ensure that you have explicit Read access to the PowerPivot file on the SharePoint Server.

Cause

The SharePoint Server is not configured to correctly handle PowerPivot files.
Did this article resolve the issue?