Power BI external tools: what they add to Desktop and when
Power BI external tools are separate programs that open from a ribbon in Power BI Desktop and connect to the model you have open. They help with jobs Desktop handles less well, such as tuning DAX, comparing models and editing many measures at once. However, most come from the community, not from Microsoft. Here is what they do and how to use them safely.
- Launch from the ribbon
- Community-built tools
- Write changes with care
Last updated
What are Power BI external tools?
They are locally installed programs that register with Power BI Desktop. Once registered, each one appears as a button on the External Tools ribbon. So an author launches it without leaving the report.
The link is automatic. Desktop passes the server name, the port and the model name to the tool. As a result, it connects to the open model without any typing.
Support is a key point. Microsoft Learn states that these programs come from third parties and the community. Microsoft supports the public interfaces they use, but not the programs themselves. Therefore check the documentation and license of each one.
Types of add-on Microsoft names for the ribbon
Microsoft Learn groups the ecosystem by purpose and gives examples. This table follows that grouping.
| Type | Example Microsoft names | Typical job |
|---|---|---|
| Model editor | Tabular Editor | Create and maintain measures and other model objects |
| DAX query tool | DAX Studio | Write, run and analyze DAX queries |
| Model comparison | ALM Toolkit | Compare two models and apply differences |
| Translation | Metadata Translator | Add other languages to model names |
| Data analysis | Excel or Python | Query the open model through a read-only connection |
| Reference | DAX Guide | Look up how a DAX function behaves |
| Custom | Your own script or program | Automate a task specific to your team |
How do Power BI external tools get onto the ribbon?
Registration happens through a small file. Each program places a file ending in pbitool.json in the External Tools folder that Desktop watches. Desktop reads that folder at startup and adds a button for each file.
Popular programs handle this themselves. Microsoft notes that DAX Studio and ALM Toolkit register automatically during installation. So most authors never see the file.
Organizations can also control the ribbon. It is on by default, but IT can disable it through Group Policy or a registry value. Also, the ribbon does not exist in Power BI Desktop for Power BI Report Server.
Three safety habits for add-ons that write to a model
A program that can change a model can also damage one, so set some ground rules.
Keep a backup
Save a copy of the file before a write operation. Then a bad change costs minutes, not days.
Know what is safe to change
Microsoft lists operations it supports, such as measures, format strings, roles and translations. Stay inside that list.
Approve installs centrally
Ask IT to review each program and its source. After that, everyone installs the same approved version.
What can Power BI external tools change in a model?
Quite a lot. Microsoft lists measures, format strings, KPIs, detail rows, translations and roles for object-level and row-level security among the write operations Desktop accepts. Desktop then syncs those changes into the open file.
Caution still applies. Microsoft warns that changes made outside Desktop can cause unexpected behavior. For example, a program may let you edit something Desktop does not expect.
Some actions stay off limits. Editing a template file is not possible this way, and neither is sending processing commands to the model. So use Desktop itself for refresh, and keep outside edits to the listed operations.
Desktop add-on questions from model authors
Does Microsoft support Power BI external tools?
Only in part. Microsoft supports the External Tools ribbon and the public interfaces that programs connect through. The programs themselves come from third parties and community authors, each with its own license and support. So read the terms before you depend on one. For a business-critical process, confirm who maintains it and how quickly fixes arrive.
Why do my Power BI external tools not appear on the ribbon?
First, check that the program finished installing and restart Desktop, because Desktop adds buttons at startup. If the ribbon itself is absent, policy is the likely cause, since IT can disable it through Group Policy or the registry. The ribbon is also absent from Power BI Desktop for Power BI Report Server. Ask your administrator before you try to work around a policy.
Can these programs break a report?
They can, if used carelessly. A program with write access changes the model directly, and Microsoft warns that edits outside Desktop may cause unexpected behavior. Therefore keep a backup, stay within the operations Microsoft lists and test the report afterward. A read-only connection, used only to run queries, carries far less risk.
Can we add a program of our own?
Yes. Microsoft documents a custom option for your own scripts and programs. You write a small registration file ending in pbitool.json and place it in the External Tools folder. Desktop then shows a button that launches your program with the connection details. Teams use this for repeat jobs, for example exporting a list of measures for documentation.
Can you review our models with this kind of software?
Yes. Power BI Agency uses programs of this kind in model reviews, for example to study slow DAX and to compare versions. We do the work online inside your own tenant and explain each finding in writing. The agency is a small team, a division of Sataware Technologies, and independent of Microsoft. Start with a free 30-minute assessment.
Let's build your first dashboard together.
Tell us what you report on today. A consultant replies within 2 hours with next steps.
Trusted partners
Microsoft Solutions Partner · AWS Partner
Cloud & AI Platforms
Azure SQL, Microsoft Fabric and the data pipelines behind your reports.
AI Business Solutions
Power BI reporting on your Dynamics 365, Business Central and Power Platform data.
Security
Row-level security and Entra ID sign-in on every report and workspace.
Amazon Web Services
Power BI on your AWS data, with connectors for Redshift, Athena and S3.