How to Connect Tableau to a SharePoint List

by | Jul 1, 2015 | BlogPosts, Tech Tips | 4 comments

Introduction

Company and organisational information is often locked up inside SharePoint and is not always easy to manipulate or visualise as Business Information. This is where Tableau comes in. SharePoint data can be manipulated or accumulated with other information in a Tableau worksheet and published;  it can even be rendered in the same or a different SharePoint site. Tableau does not have a pre-defined SharePoint connector, other than for a PowerPivot connection (excel workbook), but a connection can still be achieved easily.

This simple demonstration shows how to connect SharePoint Lists to Tableau.

Make a SharePoint List

A new data list is created in a SharePoint online portal. This list was created based on an example found on the web. The same technique will also work for SharePoint on premise. The list can be an existing custom or standard list, such as an auditing or analytics view. Import using the import app: In Site Content, select ‘add an App,’ then select ‘Import Spreadsheet’. In this case, Olympics.xlsx was used.

2015-07-01 Blog - Image 1

Note: If you get an error – “The list cannot be imported because a Microsoft SharePoint Foundation-compatible spreadsheet application is not installed or is not compatible with your browser. SP2013” – then open the 32 bit version of Internet Explorer.

A list will be created in the lists area: https://<servername>/<path>/Lists/Olympics/AllItems.aspx

2015-07-01 Blog - Image 2

Create the Connection

In Tableau (9) I defined an OData Data Source connection: “http://<servername>/<path>/<sitename>/_vti_bin/ListData.svc/Olympics

Note: If you get this error when defining the connection – “You do not have permissions from the OData source to access the data. Check with the data provider to obtain or update your permission” – then open the 32 bit version of Internet Explorer to resolve the issue.

Tableau Desktop 8.0 uses WinINet to handle HTTP requests, whereas Tableau Desktop 8.1 onwards uses libcurl. Disabling libcurl and enable WinINet will allow you to connect. Follow these steps to connect:

  1. On the Windows Start menu, click Run, type regedit, and then click OK.
  2. In the Registry Editor, navigate to HKEY_CURRENT_USERSoftware > Tableau > Tableau 8.1 > Settings.
  3. Right-click Settings, and select New > String Value.
  4. Name the new string value LegacyHttpClientEnabled.
  5. Right-click LegacyHttpClientEnabled and select Modify.
  6. In Value data, type true, and then click OK.

Retrying the OData connection gives:

2015-07-01 Blog - Image 3

2015-07-01 Blog - Image 4

This gets the List into Tableau….

2015-07-01 Blog - Image 5

Now you can manipulate the data, for instance;  create a dashboard (the image below presents an example of how to add a map to the dashboard).

2015-07-01 Blog - Image 6

Note: When you connect to SharePoint documents from Tableau Desktop, it is possible to use either a URL or a UNC path. If you use a URL, Tableau Desktop will download a copy of the data source and place it in the temp directory. Tableau Desktop will not be able to update this file when the data in the original file changes.

Conclusion

Pulling data from SharePoint is relatively easy. This is a useful technique to make use of the excellent features and functionality of Tableau and re-present the data back to SharePoint as BI style amalgamations.

Click here to view my follow-up post on how to add a live data feed from your SharePoint List to Tableau.

4 Comments

  1. Does this mean that the data that is presented from a Sharepoint list into the Tableau Dashboard is not live? We have a need to present live data from a SharePoint List into a Dashboard. The data shown in the dashboard has to be a live representation. Is this possible with Tableau?

    Reply
    • Did you ever get this to work live?

    • Hi Jay. We never tested this method to get live update data screens even though a method was suggested. The latest version of Tableau may have this capability but we haven’t explored it just yet.

Submit a Comment

Your email address will not be published. Required fields are marked *