What is My Tableau Repository?

Ever stumbled across a folder on your computer named "My Tableau Repository" and wondered what it was for? You’re not alone. For many Tableau Desktop users, this folder is a bit of a mystery, a collection of files and subfolders that Tableau creates automatically. But hidden inside is a powerful toolkit that can save you a surprising amount of time and effort. This guide will walk you through what the My Tableau Repository is, what’s inside, and how you can use it to work smarter, not harder.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly Is 'My Tableau Repository'?

Think of the "My Tableau Repository" as Tableau’s personal documents folder on your local machine. It’s where Tableau stores all your custom assets and user-specific files in one organized place. When you first install Tableau Desktop, it creates this repository for you, typically in your main Documents folder.

Its primary job is to separate your personal configurations from the main Tableau application files. This is a good thing for a few reasons:

• Upgrades are cleaner: When you update Tableau to a new version, the main application files are replaced, but your personal repository remains untouched. This means you don't lose all your custom shapes, data source connections, or color palettes.
• Organization: It keeps all your essential Tableau files neatly organized in one spot, rather than scattered across your computer.
• Customization: It's the central hub for customizing your Tableau experience, from adding branded color palettes to saving pre-configured data connections that you can reuse across multiple workbooks.

Where Can I Find It?

The location of your Tableau Repository depends on your operating system:

• On Windows: Usually found at C:\Users\[Your Username]\Documents\My Tableau Repository
• On Mac: Typically located at /Users/[Your Username]/Documents/My Tableau Repository

You can also move your repository if you prefer to store it on a different drive or in a cloud-synced folder like Dropbox or OneDrive. To do this, simply go to File > Repository Location... in Tableau Desktop and choose a new folder. Tableau will move the existing files and point all future activity there.

A Look Inside: A Tour of Your Repository's Folders

Opening the "My Tableau Repository" folder for the first time reveals a handful of subfolders. While some are for internal use, a few are incredibly useful for the everyday Tableau user. Let's break down the most important ones.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Datasources

This is arguably the most powerful folder in the repository. When you set up a connection to a database, you often spend time cleaning up the data, creating calculated fields, grouping items, making hierarchies, and setting default formatting. Instead of repeating that work every time you create a new workbook, you can save the configured connection as a Tableau Data Source file (*.tds).

A .tds file doesn't store the actual data. It’s a small XML file that stores the metadata - the instructions for how Tableau should connect to and interpret your data. It saves things like:

• Database connection information (server name, database type) or a direct link to a local file (like an Excel sheet)
• Custom calculated fields, groups, sets, and bins you’ve created
• Default properties for fields (e.g., Number Format, Default Aggregation, Colors)
• Field aliasing (renaming columns to be more human-readable)

By saving a .tds file in this folder, it becomes available in the "Saved data sources" list on Tableau’s start screen. This is a game-changer for standardizing your data definitions across your entire team.

Shapes

Ever wanted to use custom icons or images in your charts instead of standard circles, squares, or triangles? This is the folder for you. Tableau's built-in shape marks are great, but sometimes a visualization needs more specific imagery, like company logos, product icons, or warning symbols.

To add your own, simply create a new folder inside the Shapes directory (e.g., "My Custom Icons"), and then copy your image files (.png, .jpg, etc.) into it. The next time you open Tableau, that folder will appear as a new shape palette you can select from the Marks card. For best quality, these can be created as transparent background Portable Network Graphic (.png) formatted images.

Bookmarks

A Tableau Bookmark (.tbm) file lets you save a single worksheet as a standalone file. Think of it as a template or a snapshot of a single chart setup that you want to reuse.

This is useful if you’ve built a specific, complex chart that you frequently need in different workbooks. Instead of rebuilding it from scratch, you can save it as a bookmark in your repository. Then, in any other workbook, you can go to Window > Bookmarks and click on your saved bookmark to instantly add that worksheet to your current project.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Logs

The Logs folder isn't for customizing your workflow, but it’s essential for troubleshooting. Tableau records detailed information about everything that's happening behind the scenes. If you run into an unexpected error, a slow-running query, or a driver issue, the text files in this folder are the first place to look for answers.

The most commonly used files are log.txt and tabprotosrv.log. They often contain specific error codes or messages that you can use to search for a solution online or share with Tableau support.

Workbooks

This is the default save location for your new Tableau workbooks (.twb and .twbx files). It ensures all your projects are initially saved in a predictable place. Many experienced users change this default location, but for beginners, it’s a good way to keep track of your work.

Mastering Your Repository: Practical Tips and Tricks

Knowing what the folders are for is one thing. Putting them to practical use to save time is another. Here are a few ways to leverage your repository for a more efficient workflow.

1. Create Custom Color Palettes for Your Brand

Maintaining brand consistency is critical in business reporting. Instead of manually entering your company's official hex codes for every chart you build, you can add them to Tableau permanently.

This is done by editing (or creating) a file called Preferences.tps directly in the "My Tableau Repository" root directory. It’s an XML file you can open with any simple text editor (like Notepad or TextEdit).

To add a custom color palette:

1. Navigate to your My Tableau Repository folder.
2. Look for a file named Preferences.tps. If it doesn’t exist, you can create a new blank text file and save it with that name (ensure the extension is .tps, not .txt).
3. Open the file and add your color palettes using XML format. It should look something like this:

<?xml version='1.0'?>
<workbook>
  <preferences>
    <color-palette name="My Brand Colors" type="regular">
      <color>#1E3D59</color>
      <color>#FF6E40</color>
      <color>#FFC13B</color>
      <color>#F6F6F6</color>
      <color>#0E1821</color>
    </color-palette>
  </preferences>
</workbook>

Save the file and restart Tableau. Your new "My Brand Colors" palette will now be available in the color selection menu.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Standardize KPI Definitions with Saved Data Sources

Imagine your company has a very specific definition for "Active User" or "Sales Qualified Lead" that involves multiple filters and a complex calculated field. Without a standardized data source, every analyst might calculate it slightly differently, leading to inconsistent reports.

Solve this by connecting to your data, creating all the company-approved calculated fields and KPIs, and then saving it as a .tds file in your repository’s Datasources folder. Now, anyone who wants to build a report can simply connect to this saved data source, and they’ll have instant access to all the correct, pre-built logic.

3. Share Your Repository Assets with Your Team

If you're working on a team, you can standardize reporting assets by sharing key files from your repository. Create a shared network drive or cloud folder where you store your team's official .tds files, .tps color palette file, and custom Shapes folders. Teammates can then copy these files into their own local repositories to ensure everyone is working with the same branding and definitions.

Final Thoughts

The "My Tableau Repository" is much more than just a background folder, it’s a productivity engine waiting to be used. By understanding its structure and leveraging folders like Datasources, Shapes, and the Preferences.tps file, you can tame repetitive tasks, enforce brand standards, and focus your energy on finding insights rather than fighting with setup and formatting.

Mastering tools like Tableau is a fantastic skill, but we built Graphed because we believe getting insights shouldn't require mastering complex BI software in the first place. Instead of spending hours setting up data sources, tweaking color palettes, and debugging workbooks, we wanted a way to create entire dashboards just by describing what's needed in plain English. Graphed connects to your data sources like Google Analytics, Shopify, and Salesforce and uses AI to turn your simple text prompts into real-time, shareable reports and dashboards - no more manual wrangling, just instant answers.