KNOWLEDGE BASE

"The drivers necessary to connect to this database server..." Error Connecting to PowerPivot


Published: 28 Jun 2013
Last Modified Date: 24 May 2017

Issue

When you try to connect Tableau Desktop to a Microsoft PowerPivot database, the following error occurs:
 
The drivers necessary to connect to this database server are not properly installed.  Visit http://www.tableausoftware.com/drivers to download driver setup files.
It appears that you don't have Tableau PowerPivot Add-In (Excel Add-In) installed. Please install Tableau PowerPivot Add-In and try again.

Environment

  • Tableau Desktop
  • Windows 7
  • Microsoft Power Pivot add-in for Microsoft Excel 2013

Resolution

Option 1

  1. Go to the Choosing the Correct Add-In and Driver for PowerPivot article and determine if you need to install the Microsoft SQL Server PowerPivot driver.
  2. If you need to install the driver, note the type of driver that you need.
  3. Go to the Drivers page and click the download link for the appropriate Microsoft driver.
If you are still experiencing issues after you tired the solution in Option 1, try Option 2.

Option 2 

  1. Uninstall the Microsoft Office PowerPivot add-in for Microsoft Excel 2013.
  2. Reinstall the PowerPivot add-in for Excel 2013.
  3. Restart your computer.

Additional Information

For more information Microsoft Office PowerPivot add-in for Microsoft Excel 2013, see PowerPivot for Excel Installation on the Microsoft Office website.
Did this article resolve the issue?