Post
Ask Question

Integrating Tableau On SharePoint

Introduction

 
Tableau is an interactive data visualization tool that can be used to create customized dashboards and generate compelling business insights. It can help anyone see and understand their data. It empowers the users with features like the ability to connect to almost any database, drag and drop to create visualizations, and share with a click.
 
Today, let us learn how we can integrate Tableau with SharePoint as a data source. We will also see how Tableau reports can be embedded in a SharePoint page.
 

Create SharePoint List

 
Let's create a custom list with the below column names as text type.
 
You may populate some sample valid data.
 
Integrating Tableau On SharePoint
 

Setting up Tableau

 
You can download Tableau here. It comes with a 14-day trial.
 
Let's connect the SharePoint list using OData with Tableau.
 
This is how you will form the URL.
 
<yoursiteurl>/_vti_bin/ListData.svc/<List Name>
 
Please choose authentication accordingly. It gives two options - no authentication or embed user id and password.
 
Once done, the SharePoint list will be loaded as a data source. This data source can be used to generate various insights on data.
 
Tableau generates a request using OData protocol which is then processed by SharePoint.
 
SharePoint generates the output in the form of JSON or ATOM, which is then parsed by Tableau.
 
Integrating Tableau On SharePoint
 

Creating Tableau Reports

 
In this example, we will use the data to generate dynamic and interactive maps.
 
Drag Country, State, and City under Marks and Tableau will generate the latitude and longitude accordingly.
 
Fields can also be dragged to Filters to enable filtering. Go to Server on the top menu and publish your workbook on Tableau server.
 
Integrating Tableau On SharePoint
 

Permissions 

 
Tableau provides View, Interact/Edit, and Edit Permissions. More granularity can be achieved within these permission levels.
 
Add permissions accordingly to the View. This will enable authentication once you log into your organization's Sharepoint.
 
Integrating Tableau On SharePoint
 

Obtaining a link for your View

 
Click "Share" on the published View and copy the link from the Link section. Replace link in your code as mentioned below. 
 
Integrating Tableau On SharePoint 

Add Tableau report to your SharePoint page

 
Add a script editor web part on your page and insert the below code.
 
Enter the URL of your View in the src of the iframe tag. I have used 80% of the space for Tableau View as mentioned in the code below.
  1. <html>  
  2.   <body>  
  3.     <iframe align="left"   src="<your view url>"id="tableauIframe"></iframe>  
  4.     <script type="text/javaScript">  
  5. var iframe = document.getElementById('tableauIframe');  
  6.       
  7. //sizing to decide inside script editor webpart  
  8. var height = window.innerHeight;  
  9. var width = window.innerWidth;                       
  10. iframe.height = height*0.80;  
  11. iframe.width = width*0.80;  
  12.   
  13. </script>  
  14.   </body>  
  15. </html>  

Rendering Tableau in SharePoint

 
You can create filters and sort the maps according to country cities. Moreover, you can achieve other BI requirements and embed in SharePoint. 
 
Integrating Tableau On SharePoint
 

Summary 

 
Well, it is fun using Tableau in our application. Integration of Tableau with SharePoint can be achieved seamlessly using the above approach.


Similar Articles