Power BI toolkit
Validation Query Builder
Pick a check, choose measures and columns from your model, and copy a ready-to-run DAX query that validates numbers, totals, relationships or a whole table. No Copilot needed.
Clear all entries? This empties every box on this page and removes what this page saved in your browser. It can’t be undone.
Entries cleared. Paste a model export in Step 2 to start again.
Step1
Export your model from Power BI Desktop
The same query the other toolkit pages use. If you already ran it, paste those results in Step 2.
- Open your report in Power BI Desktop and select DAX query view on the left rail.
- Paste the query below into a new query tab and select Run.
- Above the results grid, select Copy. It copies every row with the column headers.
Step2
Paste the results
The page reads your tables, columns, measures and relationships so every name in the query is exact.
Step3
Choose a check
Each one answers a different question about your model.
Step4
Set it up
Step5
Run it in DAX query view
Paste into a new query tab and select Run. Rename the tab (for example Check: Sales by region) and keep it: the queries are saved in the file, so you can run the same check after every refresh.