What Type of Server Can Tableau Public Connect To?

Diving into the world of data visualization with Tableau Public is an exciting step, but it often comes with one major question: what can you actually connect it to? While it's an incredibly powerful and free tool, its data connection capabilities are different from its paid counterparts. This article will show you exactly which data sources and file types you can use with Tableau Public and how to work with data from servers that aren't directly supported.

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

First, What Is the Difference Between Tableau Public and Tableau Desktop?

Understanding the distinction between Tableau Public and the paid versions (part of the Tableau Creator license) is crucial. The core difference isn't the visualization capabilities - you can build equally stunning charts and dashboards in both - but the options for data connectivity and sharing.

• Tableau Public: A free version designed for learning and showcasing your work to the world. Anything you create and save must be published to your public Tableau Public profile. It cannot save files locally, and it has limited data-source connectors.
• Tableau Desktop (Creator): The full, paid subscription product for professionals. It allows you to connect to a massive range of servers and databases directly, save workbooks privately on your computer, and publish to a secure, private Tableau Server or Tableau Cloud.

This "public sharing" requirement is the reason for the different data connection rules. Since every workbook is public, connecting to private, live company databases would be a massive security risk. That's why Tableau Public is primarily designed to work with snapshots of data or publicly accessible files.

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

The Direct Answer: Can Tableau Public Connect to a Server?

In short, no, Tableau Public cannot connect directly to most types of live servers.

You cannot establish a live, real-time connection to databases like Microsoft SQL Server, MySQL, PostgreSQL, Amazon Redshift, Snowflake, or Oracle. A live connection means Tableau queries the database directly, pulling the most current data every time a chart is loaded or refreshed. This functionality is reserved for the paid Tableau Desktop product.

But that doesn't mean you can't use data from those servers. It just requires an extra step, which we’ll cover below. First, let's explore what Tableau Public can connect to.

What Data Sources Does Tableau Public Support?

Tableau Public is designed to work with static data files. These are self-contained files that you save on your computer or access from a specific cloud service. When you create your workbook, Tableau packages this data within the file before you publish it. Think of it as creating a self-sufficient snapshot.

1. Local Files

This is the most common use case for Tableau Public. You can connect directly to data files stored on your computer. Supported formats include:

• Microsoft Excel (.xls, .xlsx): Probably the most popular data source for Tableau Public users. It's simple, universally understood, and easy to manipulate before connecting.
• Text Files (.csv, .txt, .tab): Comma-separated values (CSV) files are the workhorse for data exports. If you're getting data from a server, you'll likely export it as a CSV.
• Microsoft Access (.mdb, .accdb): For those working with Access databases.
• JSON Files: Useful for working with data from web APIs.
• PDF files: Tableau can often correctly identify and extract tables from PDF documents, which is perfect for working with public reports.
• Spatial Files (.shp, .kml, .geojson, etc.): Essential for creating maps and analyzing geographic data.
• Statistical Files: Connect directly to files generated from statistical software like SAS (.sas7bdat), SPSS (.sav), and R (.rdata, .rda).

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

2. Cloud-Based Files (The Exceptions to the Rule)

While Tableau Public doesn't connect to cloud databases, it does have a nifty connector for one of the most popular cloud-based applications: Google Sheets.

Google Sheets

This is the closest thing Tableau Public users get to a "live" data connection. You can connect your Tableau Public workbook directly to a Google Sheet. Once you publish your dashboard, you can authorize it to stay connected to the source sheet.

This means if you update the data in your Google Sheet, the changes can be reflected in your published Tableau viz. You can even set it to refresh automatically every 24 hours. This is an incredibly powerful feature for creating dashboards from data that is updated regularly but doesn't require a full database connection (e.g., tracking marketing form submissions, simple project trackers, etc.).

Web Data Connector (WDC)

The Web Data Connector is a more advanced option. It allows you to connect to data sources on the web that don’t have a standard built-in connector. A WDC is essentially a small web page (built with HTML and JavaScript) that pulls data from a web API and formats it for Tableau.

For example, you could use a community-built WDC to pull data from a service like Spotify, Strava, or other online platforms with public APIs. However, even with a WDC, the data is pulled as a one-time extract into your workbook, not as a live connection.

You can find pre-built WDCs online for various services, or if you have some web development skills, you can build your own to connect to specific web data.

The Common Workflow: Using Server Data with Tableau Public

So if you have critical sales data in a SQL server or customer information in PostgreSQL, how can you visualize it in Tableau Public? You use a workaround: the manual data extract method.

This process sounds technical, but it’s quite straightforward:

1. Query and Export: Run a query on your database (e.g., SQL Server) to get the specific data you need for your visualization.
2. Save as a Compatible File: Export the results of your query as a CSV or Excel file and save it to your local computer.
3. Connect from Tableau Public: Open Tableau Public and connect to this newly created local file.
4. Build Your Visualization: Create your charts, dashboards, and stories as you normally would.
5. Publish to Tableau Public: Save your workbook, which uploads it - along with its packaged data - to your public profile for everyone to see.

The primary drawback is that this is a static snapshot. Your Tableau dashboard is only as current as the CSV you exported. If the data on the server updates, you'll have to repeat the entire process - export a new file, potentially reconnect it in Tableau, and republish your workbook - to see those changes.

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

When Should You Upgrade to Tableau Desktop?

Tableau Public is an outstanding tool for students, job seekers, and data enthusiasts. However, if your work involves any of the following, it’s probably time to consider upgrading to a paid Tableau Creator license:

• You need live server connections: The number one reason. If you need to analyze real-time data from a database, Tableau Desktop is a must.
• Your data is sensitive: If you're working with private company, customer, or financial data, you cannot use Tableau Public. You must have the ability to save workbooks privately.
• Dashboards need to update automatically: Tired of the manual export/re-publish routine? A paid license allows you to create dashboards that refresh on a schedule from live sources.
• You collaborate with an internal team: Professionals use Tableau Desktop to publish work to a private Tableau Server or Cloud instance, where teams can share and consume dashboards securely.

Final Thoughts

In summary, Tableau Public operates by connecting to flat files saved on your computer, like Excel spreadsheets and CSVs. It does not support direct, live connections to servers like SQL Server or PostgreSQL. The brilliant exception is Google Sheets, which lets you create workbooks that can be automatically refreshed as your sheet is updated. For everything else, the standard workflow is to export from your server and then connect Public to the resulting file.

Constantly exporting files and managing static reports can be one of the biggest bottlenecks for marketers and sales teams who need up-to-date insights. We know the pain of downloading endless CSVs every Monday morning for a Tuesday report, which led us to build Graphed. It's designed to eliminate this exact problem by letting you connect directly to all your data sources - like Google Analytics, Shopify, HubSpot, databases, and more - and build real-time, interactive dashboards just by asking questions. This approach helps you skip the data wrangling and get straight to the answers without waiting days for a report.