Can Tableau Connect to SharePoint?

Thinking about using Tableau to visualize data stored in SharePoint? It's a common goal, but the setup can feel a bit confusing at first. The good news is that you can absolutely connect them, but the method depends on whether your data is in a SharePoint List or a file like Excel or a CSV. This guide will walk you through the practical ways to connect Tableau to SharePoint and start building powerful dashboards from your data.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Connect Tableau to SharePoint in the First Place?

For many organizations, SharePoint is more than just a place to store Word documents and PowerPoint presentations. It’s a central hub for collaborative work, often holding valuable datasets that are ripe for analysis. It acts as a shared space for crucial business files and structured lists that track everything from project milestones to sales leads.

By connecting Tableau to SharePoint, you can:

• Create a Single Source of Truth: Instead of team members downloading spreadsheet versions and creating separate reports, you can build a centralized dashboard that pulls directly from the master files or lists on SharePoint.
• Automate Reporting: Build a dashboard that visualizes data from a project management list. As the team updates the list in SharePoint, your Tableau dashboard can reflect those changes automatically with a scheduled refresh.
• Visualize Collaborative Data: Imagine your sales team updates an Excel file on a SharePoint site with their weekly numbers. A direct connection allows you to build a sales performance dashboard without ever needing to ask someone to "send you the latest version."

Essentially, it turns your static, collaborative data into dynamic, actionable insights without the manual hassle of constantly downloading and re-uploading files.

Understanding Your Connection Options: Lists vs. Files

Before you dive in, it’s critical to understand that SharePoint isn't one monolithic data source. Tableau interacts differently with the two primary ways data is stored within it:

1. SharePoint Lists: These are like simple, structured databases directly within SharePoint. They have rows and columns, similar to a spreadsheet, and are used for tracking issues, tasks, contacts, or any other structured information. Tableau has a dedicated, built-in connector specifically for SharePoint Lists.
2. Files in Document Libraries: This is the more common scenario. These are the Excel workbooks, CSV files, and Access databases that you upload and store in a SharePoint document library. There is no direct "Connect to SharePoint File" button in Tableau. Instead, you need a different method to make that file accessible to Tableau, which we'll cover in detail.

Knowing which type of data you're trying to connect to is the first step to choosing the right method.

Method 1: Step-by-Step Guide to Connecting Tableau to a SharePoint List

This is the most straightforward method because Tableau was built to do it. The "SharePoint Lists" data connector allows you to pull data directly from any list you have access to. Here’s how to do it.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 1: Get Your SharePoint Site URL

First, you need the root URL for your SharePoint site, not the full URL of the specific list you want to access.

• This is what you want: https://yourcompany.sharepoint.com/sites/MarketingTeam
• This will cause an error: https://yourcompany.sharepoint.com/sites/MarketingTeam/Lists/CampaignTracker/AllItems.aspx

Navigate to your SharePoint site's home page and copy the URL from the address bar, stopping before "/Lists/" or "/Shared Documents/".

Step 2: Use the SharePoint Lists Connector in Tableau

Open Tableau Desktop and look at the "Connect" pane on the left. Under "To a Server," click on More... and then select SharePoint Lists. If you don't see it, you can use the search bar. This tells Tableau you're looking to connect to that specific type of SharePoint data.

Step 3: Enter the URL and Authenticate

A dialog box will appear. Paste the SharePoint site URL you copied in Step 1 into the text box. Next comes authentication. You will likely be prompted to sign in with your SharePoint (Microsoft 365) credentials. If your company uses Single Sign-On (SSO), this process should redirect you to your company's login page. If not, you will need to enter your username and password.

Troubleshooting Tip: If you run into authentication errors, especially in an enterprise environment, it may be due to Multi-Factor Authentication (MFA) or other security policies. You might need to check with your IT department to ensure Tableau Desktop is an authorized application.

Step 4: Select Your List and Get to Work

Once you are successfully connected, Tableau will display all the SharePoint Lists available on that site. Simply find the list you want to analyze, drag it onto the canvas, and you're ready to go! You can proceed to the worksheet tab and begin building your visualizations just like you would with any other data source.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Method 2: How to Connect Tableau to Excel or CSV Files on SharePoint

This is where things are a little less direct but arguably more common. What if your data is an Excel file your team updates in a SharePoint document library? Tableau can’t use a web URL to connect to a file, so it needs to see the file as if it were on a local or network drive.

The most reliable and modern way to achieve this is by using the OneDrive sync client.

The Best Approach: Use OneDrive Sync

Your SharePoint document libraries can be synchronized directly to your computer through OneDrive, creating a local copy that is always kept up-to-date with the cloud version. Once synced, you can connect Tableau to this local file.

Step 1: Sync Your SharePoint Document Library

• Navigate to the document library in your web browser where your file is located.
• Look for the "Sync" button in the toolbar (it usually has a cloud-like icon). Click it.
• Your OneDrive client will ask for permission. Once granted, it will create a folder on your computer that mirrors the SharePoint library. You can find this in File Explorer, usually under a folder named after your organization.

Step 2: Connect Tableau to the Local Synced File

Now that the file effectively exists on your computer, connecting it in Tableau is simple.

• Open Tableau Desktop.
• In the "Connect" pane, select Microsoft Excel (if it's an .xlsx file) or Text File (if it's a .csv).
• Navigate through your file system to the new folder that OneDrive created. It will look something like: C:\Users\YourName\YourOrganization\Site Name - Documents\your_data_file.xlsx
• Select the file, and Tableau will connect as if it were any other local spreadsheet.

The magic here is that whenever someone updates the file on SharePoint, OneDrive syncs the change to your local copy, so the next time you open or refresh your Tableau workbook, you'll see the latest data.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Connecting from Tableau Online or Tableau Server

Connecting with Tableau Desktop is one thing, but what if you publish your dashboard to Tableau Online or Server and want it to refresh automatically?

This is where Tableau Bridge comes in. When you connect to a file via the OneDrive sync method, the data source is technically on your local machine. Tableau Online has no way to access your C: drive directly.

Tableau Bridge is a client that you install on your machine which "bridges" the gap between your local network/computer and Tableau Online. It enables Tableau Online to reach back and refresh data from your synced SharePoint file, allowing you to schedule refreshes for workbooks that rely on data sources not accessible on the public web.

When you publish your data source, Tableau will prompt you to set up Bridge if it detects a local file connection, guiding you through the process.

Common Challenges and How to Fix Them

• Authentication Failures with Lists: Nine times out of ten, this is related to corporate security policies like MFA. Check with IT. Also double-check that you entered the correct base site URL, not the full list URL.
• Slow Performance with SharePoint Lists: For very large lists containing thousands of rows, a live connection can be slow. In the Data Source tab, switch your connection from Live to Extract. This creates a hyper-optimized snapshot of your data stored within your Tableau workbook, which leads to much faster performance. You can then schedule the extract to refresh on your desired cadence.
• Permission Issues: Remember, Tableau will only see what you have permission to see. If you can’t find a list or folder, check your SharePoint permissions first.

Final Thoughts

Connecting your Tableau reports to the collaborative data stored in SharePoint is a powerful way to bring your business intelligence directly where your team works. While it's not a single button click for every scenario, you have solid options. For SharePoint Lists, the dedicated connector is your best friend, and for Excel or CSV files, the OneDrive sync method provides a reliable and up-to-date bridge.

All of these steps, from managing connection paths to setting up refresh schedules, still require some manual overhead to get right. At Graphed, we aim to eliminate that friction completely. We built our AI data analyst to let you connect your data sources in seconds and create dashboards with simple, conversational language. Instead of wrangling sync clients and server settings, you can ask questions like, "Show me last month's sales by region from our master tracking sheet," and our platform builds the visualization for you in real-time. It’s ideal for marketers and business owners who want answers without the technical detour.