BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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:
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!