To connect to Microsoft PowerPivot using Tableau Desktop, you will need to install both the Tableau add-in for PowerPivot and the Microsoft SQL Server PowerPivot for Excel driver. The version of the Tableau add-in and the Microsoft driver you need to install depends on the version of Tableau Desktop, PowerPivot, and Microsoft Excel you are using. Refer to the table below to determine which Tableau add-in and Microsoft driver you will need. Then, refer to the Drivers page to download the appropriate add-in and driver.
| If you have... | You need... | |||
|---|---|---|---|---|
| Tableau Desktop | Microsoft PowerPivot | Microsoft Office/Microsoft Excel | Tableau Add-In | Microsoft Driver |
| 9.0.x | 2010 or 2012 | 32-bit | 9.0 Add-In for PowerPivot Excel (32-bit) | Microsoft SQL Server 2012 PowerPivot Excel |
| 64-bit | 9.0 Add-In for PowerPivot Excel (64-bit) | |||
| 2013 | 32-bit | 9.0 Add-In for PowerPivot Excel (32-bit) | N/A | |
| 64-bit | 9.0 Add-In for PowerPivot Excel (64-bit) | |||
| 8.3.x | 2010 or 2012 | 32-bit | 8.3 Add-In for PowerPivot Excel (32-bit) | Microsoft SQL Server 2012 PowerPivot Excel |
| 64-bit | 8.3 Add-In for PowerPivot Excel (64-bit) | |||
| 2013 | 32-bit | 8.3 Add-In for PowerPivot Excel (32-bit) | N/A | |
| 64-bit | 8.3 Add-In for PowerPivot Excel (64-bit) | |||
| 8.2.x | 2010 or 2012 | 32-bit | 8.2 Add-In for PowerPivot Excel (32-bit) | Microsoft SQL Server 2012 PowerPivot Excel |
| 64-bit | 8.2 Add-In for PowerPivot Excel (64-bit) | |||
| 2013 | 32-bit | 8.2 Add-In for PowerPivot Excel (32-bit) | N/A | |
| 64-bit | 8.2 Add-In for PowerPivot Excel (64-bit) | |||
| 8.1.x | 2010 or 2012 | 32-bit | 8.1 Add-In for PowerPivot Excel (32-bit) | Microsoft SQL Server 2012 PowerPivot Excel |
| 64-bit | 8.1 Add-In for PowerPivot Excel (64-bit) | |||
| 2013 | 32-bit | 8.1 Add-In for PowerPivot Excel (32-bit) | N/A | |
| 64-bit | 8.1 Add-In for PowerPivot Excel (64-bit) | |||
| 8.0.x | 2010 or 2012 | 32-bit | 8.0 Add-In for PowerPivot Excel (32-bit) | Microsoft SQL Server 2012 PowerPivot Excel |
| 64-bit | 8.0 Add-In for PowerPivot Excel (64-bit) | |||
| 2013 | 32-bit | 8.0 Add-In for PowerPivot Excel (32-bit) | N/A | |
| 64-bit | 8.0 Add-In for PowerPivot Excel (64-bit) | |||
| 7.0.x (starting with 7.0.7) | 2010 or 2012 | 32-bit | 7.0 Add-In for PowerPivot Excel (32-bit) | Microsoft SQL Server 2012 PowerPivot Excel |
| 64-bit | 7.0 Add-In for PowerPivot Excel (64-bit) | |||
| 2013 (7.0.14 and later only) | 32-bit | 7.0 Add-In for PowerPivot Excel (32-bit) | N/A | |
| 64-bit | 7.0 Add-In for PowerPivot Excel (64-bit) | |||
| 7.0.6 | 2010 | 32-bit | 6.1 or 6.0 Add-In for PowerPivot Excel (32-bit) | Microsoft SQL Server 2008 R2 – PowerPivot for MS Excel 2010 – RTM |