How to Get External Tools in Power BI

Power BI is an incredibly powerful tool on its own, but you can extend its capabilities even further with external tools. These free and paid add-ons integrate directly into Power BI Desktop, giving you advanced features for data modeling, DAX query optimization, and application lifecycle management. This guide will walk you through what external tools are, which ones you should know, and how to get them set up to supercharge your reporting.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Are External Tools in Power BI?

External tools are separate, third-party applications that can connect to and interact with your Power BI data model. When you install them, they appear in a new "External Tools" ribbon inside Power BI Desktop, allowing you to launch them with a single click. Think of them as plugins for your browser or apps for your smartphone - they add new functions and streamline workflows that aren't available out of the box.

While Power BI Desktop is great for building visualizations and creating basic data models, it lacks some of the advanced functionality that data professionals often need. External tools fill this gap by providing in-depth features for:

• Advanced Data Modeling: Perform complex modeling operations, create calculation groups, and manage metadata more efficiently than you can in the standard Power BI interface.
• DAX Performance Tuning: Write, analyze, and debug complex DAX (Data Analysis Expressions) formulas. You can trace query performance to find bottlenecks and optimize your report speed.
• Model Documentation: Automatically generate detailed documentation of your data model, including tables, columns, measures, and relationships.
• Application Lifecycle Management (ALM): Compare different versions of a data model, manage deployments between development and production environments, and integrate Power BI development into a source control system.

By using these tools, you can build more robust, efficient, and maintainable Power BI reports.

Popular External Tools You Should Use

Several external tools have become staples for the Power BI community. Most are free and developed by respected experts in the field. Here are a few of the most essential ones to get you started.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Tabular Editor

Tabular Editor is arguably the most essential external tool for any serious Power BI developer. It allows you to connect directly to the Tabular Object Model (TOM) that powers your Power BI dataset. There are two main versions:

• Tabular Editor 2 (Free): A lightweight yet powerful editor that excels at batch editing. You can modify multiple measures, columns, or tables at once, create calculation groups (a feature not accessible in the Power BI Desktop UI), and apply best practice rules to analyze your model for mistakes and inefficiencies.
• Tabular Editor 3 (Paid): A premium, full-featured development environment with advanced DAX editing, code assistance (IntelliSense), a built-in DAX debugger, and tools for data modeling directly within the interface.

For beginners, the free version unlocks more than enough power to significantly improve your workflows.

DAX Studio

DAX Studio is the ultimate tool for anything and everything related to DAX. If your reports are running slow or your measures are returning unexpected results, this is your go-to diagnostic tool. DAX Studio lets you:

• Analyze Query Performance: See exactly how the Power BI engine processes your DAX queries. The Server Timings feature breaks down query execution into the Formula Engine (FE) and Storage Engine (SE), helping you pinpoint whether your bottleneck is in the DAX formula or the data model structure.
• Browse and Query Your Model: Write and run DAX queries against your model to explore the data without having to build a visual in Power BI.
• Export Data: Easily export data from your model into CSV or SQL tables, which is great for validating data or handing it off for other processes.

ALM Toolkit

ALM Toolkit is a must-have for teams collaborating on Power BI projects. It's a schema comparison tool that allows you to manage Power BI datasets as they evolve. Its core function is to compare two datasets - for example, a development version and a production version - and identify the differences. You can then selectively update the target model, manage deployments, track changes over time, and avoid overwriting critical production data.

This is especially useful for maintaining separate development and production workspaces, which is a key tenet of enterprise-level Business Intelligence.

Bravo for Power BI

Bravo is a user-friendly tool that focuses on simplifying a few key tasks. It’s perfect for users who aren’t deep-dive data modelers but want to improve their reports. Its features include:

• Analyze Model: Get a quick, high-level overview of your model’s size and complexity, helping you find unused columns or tables that are bloating your file size.
• Format DAX: Automatically cleans up and formats all the DAX measures in your model according to best practices, making them easier to read and maintain.
• Manage Dates: Create a robust, feature-rich date table with a few clicks, taking the guesswork out of time intelligence calculations.
• Export Data: A simple interface for exporting data to Excel or CSV files.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Install and Set Up External Tools

Getting external tools running is surprisingly straightforward. Most popular tools have simple installers that automatically handle the integration with Power BI Desktop. Here's a step-by-step guide.

Step 1: Make Sure Power BI Desktop is Installed

External tools hook into your Power BI Desktop installation, so you need to have it on your computer first. You can download the latest version from the Microsoft Store or the official Power BI website.

Step 2: Download the External Tool

Next, download the tool you want to install from its official source. This is important to ensure you get the legitimate, latest version and avoid any security risks.

• For Tabular Editor & DAX Studio: Go to SQLBI.com
• For ALM Toolkit: Visit alm-toolkit.com
• For Bravo: Find it at bravo.bi

Save the installer file (usually a .msi or .exe) to your computer.

Step 3: Run the Installer

Close Power BI Desktop completely. Then, run the installer file you just downloaded. The installation process is typically a standard setup wizard - just follow the on-screen prompts. The installer will automatically detect your Power BI Desktop installation and create a small file in a specific folder to register itself as an external tool. No manual configuration is usually needed.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Find and Launch the Tools in Power BI

Once the installation is complete, reopen Power BI Desktop. You should now see a new tab in the ribbon at the top called "External Tools". Click it, and you'll see buttons to launch each of the tools you've installed.

That's it! To use a tool, just open a Power BI report and click the corresponding button in the ribbon. The tool will launch in a new window and automatically connect to the data model running inside your open Power BI file.

A Quick Example: Using Tabular Editor to Create a Measure

To see how this works in practice, let's perform a simple task that is much faster in Tabular Editor than in Power BI: creating a new measure.

1. Open any Power BI report (.pbix file) that contains a data model.
2. Go to the External Tools ribbon and click on Tabular Editor.
3. Tabular Editor will open in a separate window, showing you a tree-view of your data model on the left (Tables, Relationships, Roles).
4. Right-click on the Tables folder and select Create > New Measure.
5. Enter your DAX formula in the expression editor. For example: Total Sales = SUM(Sales[SalesAmount])
6. Press Ctrl + S (or click the save icon) in Tabular Editor. This does not save your .pbix file! It only saves the metadata changes to the model running in memory.
7. Switch back to your Power BI Desktop window. You’ll see a yellow bar at the top prompting you that changes have been made outside of Power BI. Don't worry, this is expected.
8. Look in your Fields pane, and you will instantly see your new "Total Sales" measure appear in the Sales table, ready to be used in visuals.
9. Now, save your report in Power BI Desktop to make the change permanent.

This process saves you clicks and allows for much faster measure creation, especially when you need to create dozens at once.

Final Thoughts

Learning to use external tools like Tabular Editor and DAX Studio is a game-changer for anyone wanting to move beyond basic reporting in Power BI. They provide the professional-grade functionality you need to build optimized, scalable, and easily maintainable data models, turning Power BI into a full-fledged enterprise BI platform.

Mastering this ecosystem is an effective way to level up your technical skills, but it's not always necessary for answering business questions quickly. We know many teams spend their time stuck wrestling with technical setups instead of analyzing marketing and sales data. That's why we created Graphed. It lets you connect your data sources - like Google Analytics, Shopify, and Facebook Ads - and use simple, natural language to build real-time dashboards. Just ask for what you want to see, and it's created for you in seconds.