WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 520 reviews for our classroom and online training
Showing DAX Studio and Tabular Editor as external tools in Power BI
Power BI automatically creates an External Tools ribbon when you install the Power BI, Tabular Editor and ALM Toolkit add-ins.

Posted by Andy Brown on 23 February 2021

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Showing DAX Studio as an external tool in Power BI

It's the little things ... I missed this Microsoft blog from October of last year announcing that you can now integrate selected third party tools into Power BI:

External tools Power BI

Two of the three external tools currently available.

The tools automatically show up on this ribbon when you install them, although you may need to update to the latest version.  You can download DAX Studio here and Tabular Editor here.

The three tools are:

Tool Notes
DAX Studio A long-established and (by Wise Owl) much loved tool for authoring DAX queries, among other things.
Tabular Editor Power BI allows you to create and edit an Analysis Services (SSAS) Tabular Model, although it doesn't advertise the fact that this is what is going on behind the scenes.  Tabular Editor allows you to pretend you're using SSAS by giving you read/write access to the underlying BIM file.  If (like the vast majority of Power BI users) you never use SSAS it's hard to see why you'd want to do this.
ALM Toolkit This toolkit is "a free and open-source tool to manage Microsoft Power BI datasets".  I confess that I'd never heard of it before writing this blog!  Judge for yourself.

The best thing about this?  When you click on the DAX Studio tool you're automatically connected to the current data model that you're using! 

This blog has 0 threads Add post