I started Power BI Helper with the intention to help to find issues in Power BI reports faster and easier. This tool over time became better and better. I’m excited now to let you know that the version 2.0 of this product is now available for everyone to use and enjoy. This version comes with these features:
- Connecting to more than one Power BI model. Selection option for the model.
- Showing the connection mode of the Power BI file.
- Showing list of tables that are NOT used in any visualization, and can be hidden from the report.
- Modeling advises
- List of both directional relationships
- List of inactive relationships
- Some minor bug fixes
If you are new to Power BI Helper, read below posts to learn what are existing features of this product:
- Version 0.1: Tables and Columns used in the visualization
- Version 0.2: Search a field or table in visualizations and filters
- Version 0.3: Measure dependency tree
- Version 1.0: Export entire M script
To Download Power BI Helper, click here:
Connecting to more than one Power BI Model
Power BI Helper, to analyze your model, needs the instance of Power BI Desktop to have the file open. Sometimes you have more than one file open in the Power BI Desktop. Previously, Power BI Helper only connected to the first instance of Desktop. Now in this version, you get a list of Power BI Models available in a drop-down list, you can choose the model, and even if you have multiple Power BI files open, then you just need to switch in the drop-down list.
If you have multiple Power BI files open in the Power BI Desktop;
Here is the view of how you can switch between models:
As you can see in the screenshot above; you can choose the file you want to connect. Also, the port for that Power BI model will be shown in a text box
Showing the connection mode of the Power BI file
Power BI files can be created in three types of connection: Import Data(or scheduled Refresh), DirectQuery, and Live Connection. It is very important most of the time to know which connection mode you have used. Power BI Helper will tell you the connection mode of a file.
Showing list of tables that are NOT used in any visualization, and can be hidden from the report
In the very first version of Power BI Helper, we had a feature that showed you tables USED in any visualization. we got lots of feedback that you like to know what are tables NOT USED in any visualizations so you can hide it from your model. we have now this feature available in Power BI Helper.
In Power BI Helper version 2.0 we introduce a new tab named Modeling advises. This tab intent to give you some best practicce advises for your modeling to help you design better Power BI model. At this stage, Modeling advises is giving you only two information; list of both directional relationships, and inactive relationships. Later on, we will add more features to this tab.
We are launching a user voice (ideas) web page for Power BI Helper to hear what features you want to add next into Power BI Helper. Please stay tuned. if there is anything you would like in the meantime, please let us know in the comment below.