Power BI Helper Version 12 (2021) Feature Summary

Power BI Helper 2021 version 12

Happy New Year. We wish this be a year full of happiness and joy for all of you. We are glad to let you know that version 12 of Power BI Helper is now available to download with the below new features;

  • Detecting the storage mode of tables (DirectQuery, Dual, Import)
  • Detecting the connection mode of the file (Import, DirectQuery, Live Connection, Composite/Mixed)
  • Report level measures
  • Compare two files based on their report level measures
  • Analyzing the visualization just by selecting the model
  • Feedback form
  • Documentation of all the above new information
  • bug fixes

Detecting the storage model of tables (DirectQuery, Dual, Import)

We’ve added a couple of columns for the table’s metadata: Storage mode, and Source. These two columns give you valuable information about the table. For example, in a composite model like below, there are different tables with different storage modes.

composite Power BI model

In Power BI Helper, you can find out the storage mode of each table

Documenting the storage mode of the tables using Power BI Helper

As you can see, the tooltip and the Source column shows where the source of the table is coming from. The Composite model to Power BI dataset is also supported.

Power BI Helper can show you if you have a DirectQuery to a Power BI dataset in the model

Detecting the connection mode of the file (Import, DirectQuery, Live Connection, Composite/Mixed)

Power BI Helper can detect what is the connection mode of the Power BI file in the visualization tab. Based on the file, the options are: DirectQuery, Live Connection, Import, or Mixed (Composite)

Documenting the connection mode of Power BI file using Power BI Helper

If the connection mode is live, the data source will be showed in the Model analysis tab.

Detecting the live connection source using Power BI Helper

Report level measures

If your file using live connection, then you might have Report Level Measures. You can see list of all the report level measures in the Visualization tab now.

Documenting report level measures using Power BI Helper

Compare two files based on their report level measures

In the prior versions of Power BI Helper, you could compare two Power BI files together based on their visualization components. Now you can also compare them based on their report level measures. This is practically useful to compare two files both with a live connection to the same data source and see what are the differences in their measures.

Compare two Power BI files based on their report level measures using Power BI Helper

Analyzing the visualization just by selecting the model

If you are connected to the model, you no longer need to select the PBIX file (this was previously needed to get the visualization analysis of the file). We have streamlined the process for you. When you connect to the model, the visualization would be analyzed automatically.

analyzing the visualization by connecting to the Power BI model using Power BI Helper

Feedback form

We value your opinion, feedback, comments, and concerns. We have embedded a form in the application so that you can contact us easier. You can choose if you wish to be contacted back (in that case make it an inquiry and provide your email address), or just provide an anonymous opinion. This option is available in the About tab.

Feedback form

Documentation of all the above new information

All the new metadata information is also available in the exported document. Below screenshot shows how the storage modes are presented.

storage modes of tables exported as a document using Power BI Helper

We hope you enjoy this new update. We are looking forward to hearing your valuable feedback and opinions.


Reza Rad on FacebookReza Rad on LinkedinReza Rad on TwitterReza Rad on Youtube
Reza Rad
Trainer, Consultant, Mentor
Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for nine continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.
He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.

Leave a Reply