How to Connect Tableau Desktop to SharePoint

Your SharePoint site is full of valuable data, from project tasks and issue trackers to contact lists and sales logs. To truly understand what it all means, you need to visualize it. This guide will walk you through exactly how to connect Tableau Desktop to your SharePoint lists and files, step by step.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Connect SharePoint to Tableau?

While SharePoint is great for storing and collaborating on information, its native reporting capabilities are fairly basic. Connecting it to Tableau transforms your static lists of data into dynamic, interactive dashboards. This allows you to:

• Discover Trends: Spot patterns in project timelines, sales cycles, or internal helpdesk tickets that are invisible in a simple list view.
• Combine Data Sources: Blend your SharePoint data with other sources. You could, for example, join a project task list from SharePoint with budget data from an Excel file to see spending per task.
• Create Rich Visualizations: Build everything from simple bar charts to interactive maps and complex funnel analyses, giving your team a much clearer view of performance.
• Share Automated Reports: Once connected and published to Tableau Server or Cloud, your dashboards can refresh automatically, saving you hours of manual reporting work.

Before You Begin: What You'll Need

Before diving in, make sure you have a few things ready. This will make the connection process much smoother.

• Tableau Desktop: This guide assumes you have Tableau Desktop installed on your computer.
• SharePoint Site URL: You need the URL of the SharePoint site that contains the list or file you want to connect to. Typically, this looks something like https://yourcompany.sharepoint.com/sites/YourSiteName.
• Access Permissions: You must have at least "Read" permissions for the SharePoint list or document library you intend to access. If you're not sure, check with your SharePoint site administrator.

It's important to know that Tableau has different ways of connecting to SharePoint depending on whether you're accessing a SharePoint list or a file (like Excel or a CSV) stored in a SharePoint document library. We'll cover both.

Method 1: Connecting to SharePoint Lists

This is the most common use case. Tableau has a built-in connector specifically for SharePoint lists. This method allows you to connect directly to the list data itself.

Step 1: Open Tableau and Find the Connector

Launch Tableau Desktop. On the main "Connect" pane on the left, you'll see a variety of data sources. The SharePoint Lists connector isn't usually listed by default.

Click on "More..." under the "To a Server" heading to see the full list of available server-based connectors. In the list that appears, select "SharePoint Lists".

Step 2: Enter Your SharePoint Site URL

A dialog box will appear asking for your connection details. Here’s the most important part: enter the main URL for your SharePoint site, not the full URL to the specific list.

• Correct URL: https://yourcompany.sharepoint.com/sites/YourSiteName
• Incorrect URL: https://yourcompany.sharepoint.com/sites/YourSiteName/Lists/Project%20Tasks/AllItems.aspx

Providing the general site URL allows Tableau to discover all the lists you have access to on that site. Leave the "SharePoint version" and "Edition" set to their defaults, unless you are using a specific on-premise version of SharePoint.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 3: Authenticate Your Account

After entering the URL, you'll need to sign in. In most cases with SharePoint Online (part of Microsoft 365), you will be prompted to sign in with your Microsoft account credentials. A pop-up window from Microsoft will appear where you can enter your email and password. This process often involves multi-factor authentication (MFA) if your organization has it enabled.

For on-premise SharePoint servers, you might have different options like "Integrated Authentication" or providing a specific username and password.

Step 4: Select Your List

Once you've successfully authenticated, you'll be taken to the Data Source page in Tableau. In the left-hand pane under "Select a list," Tableau will display all the SharePoint lists it found on the site that you have permission to view.

Find the list you want to analyze and drag it onto the "Drag tables here" canvas. Tableau will automatically display a preview of your data in the grid at the bottom of the screen. You can browse the columns and rows to confirm it's the correct data.

Step 5: Choose a Live Connection vs. an Extract

In the top right corner of the Data Source page, you'll see options for "Live" and "Extract."

• Live: Each time you interact with your dashboard, Tableau sends a query directly to SharePoint. This is good for real-time data but can be very slow, especially with large lists.
• Extract: Tableau creates a saved, high-performance snapshot of your data. This is almost always the recommended option when working with SharePoint. It makes your dashboards significantly faster and reduces the load on your SharePoint server.

Select "Extract". Then, click on any of the sheet tabs at the bottom (e.g., "Sheet 1"). Tableau will prompt you to save the extract file, and then you'll be ready to start building your visualizations with lightning-fast performance.

Method 2: Connecting to Files in a SharePoint Document Library

What if your data is in an Excel or CSV file stored in a SharePoint folder? The "SharePoint Lists" connector won't work for this. The 'official' method involves WebDAV paths and can be flaky. The easiest and most reliable method involves using the OneDrive sync client.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 1: Sync Your SharePoint Library with OneDrive

Navigate to the SharePoint document library where your file is located using your web browser. At the top of the file list, you should see a "Sync" button.

Clicking this will prompt you to open Microsoft OneDrive and set up synchronization. This creates a folder on your computer's File Explorer (or Finder on a Mac) that is a mirror of the SharePoint library. Any changes in the cloud version are automatically synced to your computer and vice-versa.

Step 2: Connect to the Local File in Tableau

Now, open Tableau Desktop. Instead of connecting "To a Server," you'll connect to a file.

Under the "Connect" pane, select the appropriate file type, such as "Microsoft Excel" or "Text file" (for CSVs/TSVs).

A file browser window will open. Navigate to the newly created OneDrive sync folder on your computer. This is usually found in your user profile folder under a folder named after your organization (e.g., C:\Users\YourName\Your Company Name\SharePoint Site - Document Library).

Select the Excel or CSV file you want to use. Just like with the list connector, Tableau will take you to the Data Source page to preview the data before you start building your reports.

Common Issues & Troubleshooting Tips

Sometimes the connection process doesn't go as planned. Here are some of the most common issues and how to solve them.

Problem: "HTTP 400 Bad Request" or Connection Error

This is almost always due to an incorrect URL. Remember to use the base site URL, not the full link to a specific list or view. Double-check that you've only included the parts up to and including the site name.

Problem: My List Isn't Showing Up in Tableau

If you connect successfully but don't see your desired list, this is a permissions issue. Your SharePoint administrator needs to grant you at least "Read" access to that specific list.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Problem: My Dashboard is Extremely Slow

This happens when you use a Live connection with a large SharePoint list. The fix is to switch to an Extract.

You can do this by going to the Data Source page (right-click your data source in the Data pane and select "Go to Data Source"), changing the setting from "Live" to "Extract," and then right-clicking the data source again and selecting "Extract" > "Refresh."

Problem: Person/Group Fields Show Up as an ID number

Complex SharePoint column types like "Person or Group," "Lookup," or "Managed Metadata" often appear in Tableau as numerical IDs instead of their text values. For example, you might see "37" instead of a person's name "Jane Doe."

Effectively using these columns requires joining your main list to hidden user lists that SharePoint maintains. A common workaround is to create a new "calculated" column in the SharePoint list itself that pulls the text value (e.g., Display Name) from the Person field, and then connect Tableau to that new, simpler column instead.

Final Thoughts

Connecting your SharePoint data to Tableau Desktop opens up a world of analytical possibilities, transforming your lists and files into powerful business intelligence assets. By using the SharePoint Lists connector for list-based data and the OneDrive sync method for files, you have a reliable way to get all of your organizational data into Tableau for analysis.

While connecting individual tools like SharePoint to Tableau is a great step, unifying all your key data sources is where the real insights are found. Piecing together data from SharePoint, then Google Analytics, then Salesforce can quickly become overwhelming. We built Graphed to solve this by creating a single hub for all your marketing and sales data. Instead of wrestling with connectors and learning new BI tools, you can simply ask questions in plain English and get real-time dashboards in seconds, pulling live information from all the platforms you rely on every day.