What "source file" means in Tableau, and why it matters
When you publish a Tableau dashboard, you are sending it to Tableau Server or Tableau Online so other people can view it. Before you publish, Tableau asks you to choose a source file — the original workbook file on your computer that contains all the data connections, calculations, and sheets that make up your dashboard. This choice determines what data your published dashboard can access and whether other people can edit it later.
The source file is not the same as the dashboard itself. Your dashboard is one piece inside a workbook file (usually named something like Sales_Analysis.twbx or Inventory_2024.twb). When you pick the source file during publishing, you are telling Tableau which workbook to link to. If you pick the wrong file, your dashboard might show outdated data, break its connections to your data sources, or prevent colleagues from making changes.
Key Takeaways
- The source file is your original Tableau workbook file on your computer, not the dashboard itself — it contains all the data connections and calculations your dashboard needs.
- Tableau asks you to select a source file when you publish; choosing the wrong one can break data connections or lock people out of editing.
- Save your workbook file before publishing so Tableau can find it and link to it correctly.
- If you have multiple versions of the same workbook, label them clearly by date or version number so you do not accidentally publish from an outdated file.
- After publishing, test your dashboard to confirm it is pulling data from the correct source and that the right people can edit it.
How to locate and save your source file before publishing
Before you open the Publish dialog in Tableau, you need to know where your workbook file lives on your computer. Open Tableau Desktop and load the workbook that contains your dashboard. Go to File > Save As (or Save if you have not saved it yet). Note the file name and the folder path — this is your source file.
Workbook files come in two formats: .twb files (Tableau Workbook) store your sheets and calculations but keep data connections separate, while .twbx files (Tableau Workbook Packaged) bundle everything together, including a snapshot of your data. For publishing, either format works, but .twbx files are safer if your data source might move or become unavailable later.
If you have not saved your workbook yet, Tableau will prompt you to save before publishing. Do this now. Give the file a clear name that describes what it contains — for example, Q1_Sales_Dashboard_2024.twbx rather than Dashboard_Final_FINAL_v3.twbx. Save it in a folder you can find again, ideally on a shared drive if you work with a team.
Selecting the source file in the Publish dialog
Once your workbook is saved, go to File > Publish to Tableau Server (or Publish to Tableau Online if you use the cloud version). A dialog box opens asking you to sign in to your server and choose where to publish your dashboard.
Near the bottom of this dialog, you will see a field labeled Source File or Source Workbook. Tableau usually fills this in automatically with the file you currently have open. Check that the file name and path match the workbook you want to publish. If it does not, click Browse or the folder icon next to the field and navigate to the correct file on your computer.
Do not leave this field blank or let Tableau guess. Take the extra five seconds to confirm you are pointing to the right file. This is the single most common place people accidentally publish from an outdated version.
Avoiding version confusion when you have multiple copies
Many people keep several versions of the same workbook — maybe one for testing, one for last month, one for the current month. This is good practice for backup, but it creates a risk during publishing: you might accidentally select the wrong version.
To prevent this, use a consistent naming system. Include the date or version number in the file name itself: Sales_Dashboard_2024_01_15.twbx or Inventory_v2_current.twbx. Keep old versions in a separate folder labeled "Archive" or "Previous Versions" so they do not clutter your active workspace. When you open the source file browser during publishing, the file names will tell you when ready which one is current.
If you are not sure which version is newest, right-click the file in Windows Explorer or Finder and check the "Date Modified" column. The most recent date is your current version. Open that file in Tableau, verify it contains the data and sheets you want to publish, and then proceed with publishing.
What happens after you select the source file
Once you confirm the source file and click Publish, Tableau uploads your dashboard to the server and creates a link between the published version and your source file. Other people can now view the dashboard on the server. If your source file contains live data connections (to a database, Excel file, or API), the published dashboard will pull fresh data each time someone opens it.
If you gave other people permission to edit the published dashboard, they can read the source file from the server, make changes in Tableau Desktop, and republish. This only works if the source file is accessible and the permissions are set correctly. If you selected the wrong source file during publishing, those edits might fail or overwrite the wrong version.
After publishing, open your dashboard on the server and check that it displays the correct data. If something looks wrong, go back to your source file, make corrections, and republish. Tableau will update the server version automatically.
Fixing a source file mistake after publishing
If you published from the wrong source file and realized it afterward, you have two options. The simpler one: open the correct source file in Tableau Desktop, go to File > Publish to Tableau Server, and republish to the same location on the server. When Tableau asks if you want to overwrite the existing dashboard, click Yes. This replaces the incorrect version with the correct one.
The second option, if you need to keep both versions: publish the correct file as a new dashboard with a different name. Then go to the server and delete the incorrect dashboard. This is cleaner if the wrong version has already been shared with people or bookmarked.
To avoid this situation in the future, test your dashboard on the server before you share the link with others. Open it, click through the sheets, and confirm the data matches what you see in your source file. This takes two minutes and catches most mistakes.
Frequently Asked Questions
Can I change the source file after I have already published?
Yes. Open the new source file in Tableau Desktop, go to File > Publish to Tableau Server, and republish to the same dashboard name. Tableau will ask if you want to overwrite the existing version. Click Yes. The server will now use the new source file for all future updates.
What if my source file is on a network drive that goes offline?
If your source file is on a shared drive and that drive becomes unavailable, your published dashboard will not be able to refresh its data. Use a .twbx file instead, which packages a copy of your data inside the file itself. This way, the dashboard works even if the original drive is down, though the data will not update automatically.
Do other people need access to my source file to view the published dashboard?
No. People viewing the dashboard on the server do not need access to your source file. Only people who want to read and edit the dashboard in Tableau Desktop need to access the source file, and only if your server permissions allow it.
What is the difference between publishing and exporting?
Publishing sends your dashboard to Tableau Server or Online so people can view it in a browser. Exporting saves your dashboard as a PDF, image, or data file on your computer. Publishing requires you to select a source file; exporting does not.
If I move my source file to a different folder, will my published dashboard break?
It depends on your data connections. If your source file connects to a database or API, moving the file does not break anything — the dashboard still reaches the data source. If your source file connects to a local Excel file, moving the source file might break the connection unless you update the data source path in Tableau first.