How to Export or Connect Tableau to Power BI (There Is No Export Button)
September 30, 2026
There is no export button and no direct way to export Tableau to Power BI: Tableau Desktop has no Export to Power BI command, and the Power Query connector list that Power BI uses has no Tableau entry, so Power BI cannot open a workbook, a published data source or an extract. What people mean by "export Tableau to Power BI" is one of five different jobs, and each has a route that works. The right route depends on the job.
What "export or connect Tableau to Power BI" usually means
| What you want | Route that works | What you get | What you do not get |
|---|---|---|---|
| The data behind a Tableau dashboard, in Power BI | Reconnect Power BI to the same source; export the extract if the source is gone | Tables to model | Visuals, calculations, filters |
| The dashboard itself, in Power BI | Rebuild by hand, or convert the workbook definition with a tool | A report page and a semantic model | A file that opens as-is |
| A Power BI semantic model, read from Tableau | Tableau's Analysis Services connector over the XMLA endpoint | A live connection to the model | Tableau support; the connector is documented as not for production |
| A Power BI report shown inside a Tableau dashboard | Secure embed URL in a Web Page object | Both tools on one screen during coexistence | Cross‑filtering between them |
| Both tools reading the same numbers | One shared source or warehouse layer feeding both | Agreement at the table level | Agreement on calculations built in the tools |
Why there is no export button
Tableau's own export documentation is entirely about data: CSV from the data source page, crosstabs to Excel, view data to Access or CSV. Nothing in it produces a Power BI artifact, because the two formats describe different things (the detail is on workbook to PBIX conversion), and as of September 2026 the only BI vendor with an in‑product importer for another vendor's workbook files is Databricks, whose Genie Code importer reads .twb, .twbx, .tds, .tdsx and .pbit files and lands the result in Databricks AI/BI, not in Power BI.
The connect phrasing fails for the same reason. Power BI connects to databases, files, services and other Power BI semantic models; a Tableau published data source is none of those, and Tableau exposes it to Tableau clients and its own APIs, not over a database protocol.
Route 1: get the data out of Tableau
If the source system behind the workbook still exists, point Power BI at it directly and you inherit a refreshable query. Every route below produces a snapshot that nobody can refresh, so treat it as a bridge for sources that have gone away.
| Route | Where | Produces | Best for |
|---|---|---|---|
Data > Export Data to CSV | Tableau Desktop, data source page | CSV of the whole data source | One table, once |
Worksheet > Export > Data or Crosstab to Excel | Tableau Desktop, a view | What one view shows | Reconciliation baselines |
| Hyper API | Script against a .hyper file | CSV or Parquet per table | Many extracts, repeatably |
| REST API Query View Data | Tableau Server or Tableau Cloud | CSV per view (a dashboard request returns its first view only) | Scheduled pulls without Desktop |
| REST API Download Data Source | Tableau Server or Tableau Cloud | .tdsx, with or without the extract | Recovering the extract inside a packaged source |
| REST API Download Workbook | Tableau Server or Tableau Cloud | .twb or .twbx with any embedded extract | Bulk retrieval before a conversion; see Tableau Cloud to Power BI |
| VizQL Data Service | Tableau Cloud, Tableau Server 2025.1 or later | JSON query results from published sources | Programmatic reads with Tableau's own semantics |
Two caveats apply to every view‑level export. Tableau warns that an export may exclude some table calculations and level of detail expressions, because those are computed in the view, and fields on the Filters shelf are left out unless they also sit on Detail. The CSV carries the data; the dashboard's logic gets rebuilt as DAX, which is covered under LOD expressions and table calculations. Extract mechanics, including the fact that a packaged .tdsx carries a copy of the extract, are on Hyper files to Power BI; how a published data source becomes a shared semantic model is on data sources to semantic models.
Route 2: move the dashboard itself
Because no file conversion exists, moving a dashboard means regenerating a report page and a model from what the workbook describes. A rebuild reads the Tableau dashboard as a specification and authors the Power BI version by hand, which is also the moment most teams redesign. A conversion tool generates the model and report from the workbook definition and leaves review to people. Either way the same items decide the effort: LOD expressions, table calculations, dashboard actions, data blending and custom SQL, none of which map one to one. The migration guide walks the whole list, and automated migration is specific about what converts cleanly and what does not.
Can Tableau connect to a Power BI semantic model?
Yes, with a warning attached. Power BI semantic models on Premium, Premium Per User or Fabric capacity expose an XMLA endpoint, read‑only by default, and Microsoft lists third‑party visualization tools among the clients that can query it. Tableau's Microsoft Analysis Services connector speaks that protocol, so Tableau Desktop on Windows can open a Power BI model as a cube.
Tableau's Fabric connector page documents the steps and then says, in as many words, that the connector is not recommended for production situations and not supported by Tableau, citing schema resolution issues and functionality gaps between Tableau and the semantic model engine. Its recommended Fabric route is the Azure SQL Database connector against a warehouse or lakehouse SQL endpoint, which reaches tables, not the model. Use the XMLA route only while both platforms are live, and plan for it to be gone by cutover.
How to run Tableau and Power BI side by side
Migrations of any size run both platforms in parallel for a period, and "connect" often means making that period bearable. A Power BI report can be placed inside a Tableau dashboard through a Web Page object holding Power BI's secure embed URL; viewers sign in to Power BI inside the frame and, unless both the report and its semantic model sit on Premium or F64‑plus capacity, each needs a Pro or Premium Per User license. A shared warehouse layer keeps both tools reading the same tables, leaving only the calculations to reconcile. And the Tableau Metadata API answers, per workbook, which databases and tables it touches, which is the inventory that decides what moves in which order. One rule keeps the parallel period short: once a dashboard is converted and validated, changes go to the Power BI version only, or the validation has to be repeated.
What Antares does here
Antares is a BI migration tool for Route 2. The Analyzer connects to Tableau Server or Tableau Cloud, reads metadata only, never business data, and returns the inventory: every workbook, what each data source points at, whether it is live or extract‑backed, and which dashboards carry the constructs that do not map one to one. It is free and fully deterministic. The Converter takes a source dashboard and produces a Power BI report page with its semantic model, deployed into a Fabric workspace, at a flat $200€200 per source dashboard, with LLM costs on top, typically under $20€20 per dashboard. It converts dashboards, not databases: live sources are reconnected on the Power BI side, which is Route 1. Run the free Analyzer to see which route each of your dashboards needs.
Related reading: workbook to PBIX conversion, Hyper files to Power BI and data sources to semantic models. Primary sources: Microsoft on data sources in Power BI Desktop and the XMLA endpoint; Tableau on exporting data, saved data sources, the REST API, the VizQL Data Service and the Hyper API.
← Back to the Tableau to Power BI Migration guide
Related Migration Resources
Frequently asked questions
Is there a Tableau connector in Power BI?
No. Power BI gets data through Power Query, and the Power Query connector list has no Tableau entry, so Power BI cannot read a workbook or a published data source. Connect Power BI to the database or files the Tableau workbook reads instead.
Can Tableau connect to a Power BI semantic model?
Technically, through Tableau's Microsoft Analysis Services connector against the model's XMLA endpoint, which needs Premium, Premium Per User or Fabric capacity. Tableau's own documentation says this configuration is not recommended for production and not supported by Tableau, so plan for it to be replaced before cutover.
Does Export Data in Tableau give me the dashboard?
No. It writes the rows a view shows. Export Data and Crosstab to Excel carry the data of one view, Tableau warns that some table calculations and level of detail expressions may be excluded, and fields on the Filters shelf are left out. Visuals, filters and calculations are rebuilt on the Power BI side.
Is there a Tableau to Power BI dataflow connector?
No. A Power BI dataflow reads from the same Power Query connectors as a report, and Tableau is not among them. Point the dataflow at the source Tableau was reading; whether an extract should become a dataflow at all is a separate question, covered on the extracts-to-dataflows page.
Can Power Query read Tableau data?
Not from Tableau itself. Power Query has no Tableau connector; it reads the database or files behind the workbook, or a CSV or Parquet file exported from Tableau Desktop, the REST API or the Hyper API. Reconnecting to the original source is the only route that stays refreshable.