Connecting to SharePoint-Based Excel File

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.

In order to connect to a file hosted on SharePoint, you will need to verify the following: 

• 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. 
• On Windows, 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. For more information about displaying a Sharepoint library as a UNC path, see this article UNC Path Naming for files stored on SharePoint.  
• On a Mac, you will need to use OneDrive to sync the files. For more information, see Add and sync shared folders to OneDrive at Microsoft support.