Connecting to Files Hosted on SharePoint Online or Office 365

Published: 04 Aug 2016
Last Modified Date: 08 Jul 2022


How to connect to files hosted on SharePoint Online or Office 365.


  • Tableau Server 
  • Tableau Desktop
  • Excel
  • CSV
  • SharePoint Online
  • Office 365


To connect to a file stored in a SharePoint list, try one of the following workarounds. In both scenarios, you can connect to the file and publish an extract. You will not have the ability to schedule a refresh. 

Option 1

Option 2

Option 3

Additional Information

Tableau has the ability to connect to a SharePoint list using the built-in connector. This will pull in SharePoint Metadata from the list. 
For example:
 "Calendar" list will have metadata - Subject, Start date, End Date, Attendees, etc. 
 "Document Library" list will have metadata - File Name, Upload Date, Modified Date, Modified by, etc
For more information on connecting to a SharePoint list, see SharePoint Lists

However, connecting to a file stored in a Document Library, which is also a SharePoint list, is not currently supportedTo voice your support for the inclusion of this feature request in a future product release, add your vote to the following Community Idea: MS Office 365 Connectivity.

Discuss this article... Feedback Forum
Did this article resolve the issue?