Power BI toolkit

SF Power BI Toolkit

Tools for designing, building, checking and explaining Power BI reports and models, with or without Copilot. They’re grouped in the order a report gets built.

Check everything before you use it. AI can make mistakes, and generated output can be wrong. The toolkit is provided as is, without warranty, and you use it at your own risk. Read the full disclaimer.

Connect your model onceTools marked Uses your model read it. Export it once here and every tool picks it up. The rest work without it.

Step1

Export your model from Power BI Desktop

One DAX query lists the model’s tables, columns, measures (with their formulas and descriptions) and relationships. It reads the model’s definition only, not your data.

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.

DAX query: model export

Tip: rename the query tab to Toolkit export and keep it. DAX query view saves it in the file, so next time you only select Run and Copy.

Step2

Paste it once

It’s saved in this browser and shared by every tool on this site. Paste a new export whenever the model changes.

Model name (optional, shown in each tool)

Saved your report as a Power BI Project (PBIP)? You can skip the export: choose PBIP folder in any tool’s Connect your model step, and every other tool picks it up too.

Good to know

Nothing leaves your browser. The pages don’t send data anywhere. Prompts only reach Copilot when you paste them yourself.
Where the export is kept: in this browser’s storage for this site, so it’s there next time on this computer, but not on another computer or in another browser.
One export at a time. Pasting a model export into any tool also replaces the saved one, so every tool stays on the same model.
Each tool keeps its own work (requests, replies, settings). Its Clear entries button empties that tool only, and the saved export stays until you remove it here. To empty every tool and remove the saved export at once, choose Clear all pages there or below.
The Power Query Explainer reads Power Query code, so its whole-model mode has its own export query. The Date Table Generator fills its date-column list from the saved export.
The Model Documenter uses the saved export for a quick document, or reads a PBIP project folder in the browser for the full one (Power Query, sources and report pages). The folder’s files are read on the page and never uploaded.

Disclaimer: use at your own risk

AI can make mistakes. Copilot replies can be wrong, incomplete or out of date, and can refer to tables, columns or measures that don’t exist. The pages check what they can (names, syntax, some results), but they can’t catch every error in logic or meaning. Read every reply before you use it.
Check all of the work. Everything the toolkit produces, with or without AI (DAX, Power Query, TMDL scripts, descriptions, themes, documents and lint findings), is a starting point to review, not a finished answer. Confirm results against figures you trust before anyone relies on them.
Test on a copy first. Scripts can add, replace or change objects in your model. Back up the report or keep it under version control (PBIP and Git), and apply changes to a copy before a production model.
No warranty, no liability. The toolkit is provided free and “as is”, without warranty of any kind, express or implied. Foster BI Services accepts no liability for incorrect information, errors, data loss, downtime, or any other loss or damage arising from using it or relying on its output. You use it at your own discretion and risk.
Follow your organization’s policies. Only paste prompts into AI tools your organization approves. A model export holds no data rows, but table, column and measure names, formulas and descriptions can still be confidential; treat them the way your data policies require.
Shared computers. Exports and work are saved in this browser. On a shared or public computer, clear everything when you finish.
Not a Microsoft product. This toolkit isn’t affiliated with or endorsed by Microsoft. Power BI and Copilot are trademarks of Microsoft Corporation.