Microsoft PowerPivot

This example discusses how to connect Tableau to a Microsoft PowerPivot database.

1. Select Data > Connect to Data to open the Connect to Data page.
2. Select Microsoft PowerPivot.
3. Follow the steps in the Microsoft PowerPivot Connection dialog box to complete the connection.
   1. Step 1 – Select whether to connect to a PowerPivot file on SharePoint or a local Excel file.
      If you are connecting to SharePoint type the URL or specify a UNC File Path. You can use the Browse button to select the file. If you are connecting to a local Excel file, click the Browse button to navigate to the file you want to connect to.
      If you plan to publish the workbook to Tableau Server, make sure to connect to a PowerPivot file on SharePoint. Tableau Server does not support connections to local PowerPivot files.
   2. Step 2 – Test the connection.
   3. Step 3 – Give the connection a name for use in Tableau.
      Specify a unique name for the connection. The default name is automatically generated based.

A completed Connection dialog box for Microsoft PowerPivot is shown below.