Last Modified Date: 21 Sep 2012
The information stored in SharePoint server lists can be a valuable resource. You can easily access SharePoint list data with Tableau using an OData connection that points to the List Data Service of your SharePoint 2010 server. The List Data Service is only available in SharePoint 2010 and later.
Important: Tableau does not support or test OData connections to SharePoint list data. This article is intended to provide general guidance on certain configurations that may allow Tableau to connect to SharePoint list data using OData.
Go to the SharePoint list that contains the data that you are interested in. The image below shows a sample list that contains donor information.
In a browser, type the following URL: http://<servername>/_vti_bin/ListData.svc.
In this example, the URL is http://sharepoint/_vti_bin/ListData.svc . The SharePoint server has returned a list of “data feeds” that you can access. The desired data feed is DonorRecords.
Note: Replace <servername> with the name of your server.
Open Tableau, and click Connect to Data.
On the Connect to Data page, select OData.
In the OData Connection dialog box, type the URL that points to the data feed you want to access. This URL is a combination of the path to the List Data Service and the name of the list you want.
In this example, the URL is: http://sharepoint/_vti_bin/ListData.svc/DonorRecords.
Click the Connect button.
Tableau displays a list of available dimensions and measures from the data feed. Many of these fields are used internally by SharePoint and may not be useful to you. Examples of these fields include the following:
Note: This list is not inclusive. You may see fewer or more internal SharePoint fields depending on what type of list you choose to access.