KNOWLEDGE BASE

Connecting to SharePoint-Based Excel File


Published: 30 Jul 2014
Last Modified Date: 30 Jun 2017

Question

How to connect to Excel files hosted on SharePoint.

Environment

  • Tableau Desktop
  • Microsoft SharePoint

Answer

You can connect to Microsoft Excel files hosted on SharePoint using the Microsoft Excel data connection in Tableau Desktop. For more information, see Microsoft Excel.

Note: In order to connect to a file hosted on SharePoint, you will need to verify the following: 
  1. Store the file on the SharePoint local file system. Files stored in the SharePoint content database don't have physical file paths and cannot be accessed by Tableau Desktop. 
  2. Use the Universal Naming Convention (UNC) path, or network path, to connect to the data source. For example, connect to a path that looks similar to \\servername\sharename\directory\filename

Additional Information

A UNC path is the full name and directory path of a network resource. The UNC path will follow a standard syntax such as: \\servername\sharename\directory\filename syntax, where servername is the name of the server, sharename is the name of the shared resource and directory\filename is the directory path to the file. 

In Windows, the UNC path is often referred to as the network path. 
Did this article resolve the issue?