KNOWLEDGE BASE

Error "Exception from HRESULT" Connecting to PowerPivot


Published: 22 Jan 2013
Last Modified Date: 23 Jun 2017

Issue

When you try to connect to Microsoft PowerPivot, the following error might occur:

An error occurred while communicating with the data source
Exception from HRESULT: 0x800A03EC 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
  • Microsoft PowerPivot

Resolution

  1. Open the PowerPivot data in Excel. 
  2. Go to the sheet that contains the PowerPivot. 
  3. Select the Tableau tab in the ribbon. 
  4. Click on Pivot to table.
  5. Save the Excel file, and then connect to it from Tableau by clicking Open in Tableau.

Cause

The "Exception from HRESULT" error occurs when the PowerPivot data is not linked to an Excel worksheet.
Did this article resolve the issue?