Quick intro + final dashboard
- If you’ve ever tried to move a Power BI project to another BI tool, you know the pain point: the dashboard itself is easy. But the hard part is everything underneath it. So here’s the test. This is a Power BI report. And this is the same report, migrated into Holistics.
- At first glance, layout matches, filters are in the same places, the sales amount matches. If I filter by a year, the numbers should show the matched numbers. But the part that actually matters is what’s behind this dashboard, let me show you.
- Power BI has an option to export sources as code, which is TMDL + DAX.
- Holistics represents target as code, AMQL.
- Here is the conceptual mapping between 2 platforms.
Workflow
- In the demo today, I will do it with the help of a coding agent.
- I’m in Claude Code, with a skill called
holistics-migrate-power-bi. And I’m just going to give it a plain English prompt: “migrate this pbi project into holistics using the holistics-migrate-power-bi skill”. - While we’re waiting for agent’s result, let’s take a look at the Power BI source: tables, relationships, every DAX measure, every report page.
- Then it writes the Holistics project. Tables become AML models. The semantic model becomes a reusable dataset.
- Here’s the part buyers care about most. A year-over-year DAX measure on the left, the translated Holistics metric on the right. The point isn’t the syntax — it’s that the business logic is no longer trapped in a
.pbix. It’s code. You can read it, edit it, review it in a pull request. And if your team prefers SQL, you write the metric in SQL. No language tax. - In Claude, you would see the agent runs
holistics aml validate, executes queries against the warehouse, compares the results. Migration becomes a code-review loop. - This is not one-click magic. Complex DAX, or RLS still need human review. But if the first draft gets created in minutes, and the rest of the work becomes much easier, much faster instead of a manual rebuild.
- If you’re considering a Power BI migration, send us your report, or your scariest DAX measure. We’ll show you what the first Holistics draft looks like.