Tableau to Power BI Migration in Healthcare: Moving Dashboards Without Moving Patient Data
September 4, 2026
Converting a dashboard does not require access to patient data. What moves is structure: field references, calculation logic, filters, layout. The rows stay where they are. The exposure in a healthcare migration sits in the artifacts that accumulate around the work, beginning with packaged workbooks that carry an extract inside them.
Nothing about the process is healthcare-specific; the constraints laid over it are. The process is on the migration guide. This page is about keeping protected health information out of the migration itself, and about the one architectural question that decides how much rework a clinical estate needs.
What a dashboard migration actually touches
The input to a conversion is workbook metadata: which fields a view references, how calculated fields are written, what the filters select, how the objects are arranged, and how the connection to the source is defined. None of that is a patient record. A conversion step can therefore run in a setting where nobody involved has rights to read a row, which is not true of the rest of the project.
Metadata is not nothing, though. Field names, calculation logic and hard-coded filter values describe a population without containing any rows of it, and Tableau notes that filter values alone give semantic clues to the data. Treat the inventory as internal material with a named owner: a smaller problem than the one below, but not zero.
Where PHI leaks during a migration
| Migration artifact | Can it hold patient data | What to do about it |
|---|---|---|
Packaged workbook (.twbx) with an embedded extract | Yes. Tableau documents the contents of the file as plain text, readable by anyone who opens it | Keep downloads inside the controlled environment, never as an attachment |
| Screenshots for documentation and acceptance | Yes, and the easiest artifact to forget | Capture against de-identified or synthetic data, and store with the project |
| Excel or CSV exports taken during reconciliation | Yes, at row level, exactly the level reconciliation tempts you to | Compare inside the environment; export aggregates if at all |
| Screen sharing on a review or demo call | Yes, to everyone on the call and to the recording | Use a de-identified dataset, or restrict the attendee list |
| Ticket attachments and chat threads | Yes, and they outlive the project | Reference record identifiers or report links rather than values |
| Non-production environments loaded from a production copy | Yes, under weaker access controls | Subset or de-identify before the refresh, not after someone notices |
| The metadata inventory itself | No rows, but field names and filter values are descriptive | Handle as internal; assign an owner and a retention decision |
Leaks happen where the controlled environment meets the convenience of getting work done. Deciding once where migration work physically happens, and what may leave, removes most of the table at a stroke. Power BI's sensitivity labels extend the same discipline to the target, since a label follows content into Excel, PowerPoint and PDF exports.
How to validate without exposing patient data
Split validation in two, because the halves need different people. Structural validation asks whether the report page carries the same fields, filters, interactions and layout, and whether measures behave the same. It runs on de-identified or synthetic data and can involve anyone. Numeric reconciliation needs real data and belongs to a restricted group working inside the environment.
In the second half, compare aggregates rather than exporting row-level detail, and record what was checked: source of truth, as-of point, method, tolerance, named sign-off. That evidence template is set out on the financial services page, and it applies unchanged here. Microsoft treats creating and validating content as a single stage for the same reason: a report is not finished when it looks right.
Why clinical sources are usually reached through a warehouse
Clinical systems rarely serve reporting directly. Most estates read from a warehouse or reporting layer that already applies the de-identification, the encounter grain and the agreed definitions. Good news for a migration: the converted semantic model points at the same warehouse, and connection rework is a credentials and gateway task, not a modeling project.
Where dashboards bypass that layer with custom SQL against a clinical database, the shape of the project changes. Those queries get rebuilt as model logic or pushed back into the warehouse, which is data-platform work with its own owners and timeline. Custom SQL to Power BI and data sources to semantic models cover the mechanics; for planning, it is a separate workstream.
Access restriction moves with the model rather than with the report, which is worth mapping before the first conversion.
| Restriction | Usual Tableau implementation | Power BI equivalent |
|---|---|---|
| By facility or site | User filter on a facility field | An RLS role filtering the facility dimension |
| By department or service line | User filter, or a dashboard filter treated as security | An RLS role; a hidden dashboard filter is not security on either platform |
| To a clinician's own patients | Dynamic filter against an entitlements table | A dynamic RLS role on the same entitlements table |
One warning carries over from the access-heavy version of this migration: row-level security applies to viewers, not to workspace members, so distribution through apps matters more than it did in Tableau.
What Antares does in a healthcare migration
Antares is a BI migration tool, and metadata-only is the literal answer to the question this page asks. The free Analyzer reads what the workbooks declare, never the business data behind them, and returns the inventory: usage, sources, calculations needing attention, complexity per dashboard. It is deterministic, runs inside your own environment, and changes nothing in the source. The Converter turns each source Tableau dashboard into a Power BI report page for a flat $200, no per-user licensing and no time limit, LLM costs going to your own provider at typically under $20 per dashboard, private endpoints supported where model calls must stay inside your boundary.
What it does not do matters as much. It is not a data migration tool: clinical data is not moved, no warehouse is built, nothing is de-identified on your behalf. Conversion is deterministic-first with guardrailed, validated AI steps, like-to-like rather than a redesign, and mappings it cannot resolve confidently are flagged instead of guessed. On business associate agreements, residency and retention we make no claims about certification or regulatory status; put those to your own privacy and security review with the technical facts in hand. Run the free Analyzer before anyone downloads a workbook.
Related reading: access and provable numbers, custom SQL to Power BI and the Analyzer. Primary sources: Tableau on packaged workbooks, plus Microsoft on data protection in Power BI and security planning.
← Back to the Tableau to Power BI Migration guide
Related Migration Resources
Frequently asked questions
Does converting Tableau dashboards to Power BI require access to patient data?
The conversion itself does not. What a conversion reads is workbook metadata: field references, calculation logic, filter definitions, layout and connection details. Numeric reconciliation later does need real data, which is why validation is worth splitting into a structural half that anyone can do and a numeric half restricted to people already cleared for the source.
What is the biggest patient-data exposure in a migration project?
Downloaded packaged workbooks. A .twbx can contain an embedded extract, and Tableau documents that the file's contents are stored in plain text and readable by anyone who opens it. Bulk exports out of Tableau are therefore a data movement event, and they belong inside the controlled environment rather than in tickets, shared drives or laptops.
Can we validate converted reports using synthetic or de-identified data?
For structural validation, yes, and it is the better default: layout, fields, filters, interactions and measure behavior can all be checked without real records. Numeric reconciliation against the source of truth still needs production data, so restrict who performs it, keep the comparison inside the environment, and compare aggregates rather than exporting rows.
Do we need a business associate agreement with a migration tool vendor?
That determination belongs to your privacy office, and it applies to every vendor in the workflow rather than to migration tools specifically. Bring them the technical facts: Antares reads metadata rather than business data, can run inside your own environment, and can call your own private LLM endpoints. We make no claims about our regulatory or certification status.