We have some bug fixes and small features that make a big improvement in using Power BI Helper. In this post, you will learn about the new features added in Power BI Helper in November 2020 edition. in a nutshell, here are updates;
- layout for different sizes of screen
- splitters for a better UI
- cross-filtering workspaces to dashboards/reports/dataset and dataflows
- export metadata
- the result of DMV execution
- the metadata of the service tab
- the metadata of the visualization tab
- bug fixes
How to install the latest version of Power BI Helper?
Download the latest version of the Power BI Helper, and install it. That’s it. Simple as that.
Download Power BI Helper from here:
Support for different screen sizes and resolutions
Although Power BI Helper is not supported for mobile screens. You can however, get it working in different screen sizes and resolutions beautifully in this latest version.
here are some views of the visualization tab in different screen sizes;
Splitters for a better UI
We’ve also added visual splitters here and there in the pages and tabs so that you can customize the view as you want.
Cross filter to see all the content in a workspace
Previously in Power BI Helper’s Service tab, you could see all the workspaces, reports, dashboard etc. What we have added in this version is the ability to select a workspace in the left side and see all the content of it (dashboards, reports, datasets, and dataflows) in the right hand side.
Export metadata as CSV
A very common request amongst the users was to have the ability to export the metadata as CSV files.
For most of the pages we added an option to “Export all metadata” which does this action.
We have added this functionality in a few tabs as below:
Export the result of a DMV execution
When you run a DMV, you can export the output of that into a CSV file
Export metadata from the Power BI Service
This includes everything from the Power BI service based on your account’s access level. Including but not limited to workspaces, reports, dashboards, datasets, dataflows, apps, configurations, data sources, gateways.
Export metadata from the Visualization
This includes all reports, bookmarks, visualizations, fields, and tables that have used or not used in visuals.
How about M Script?
The M script tab’s functionality is changed after the change in the recent versions of the Power BI file’s metadata. If you can’t get the script in this tab, try using the DMV Explorer tab, and select the TMSCHEMA_Partitions. the QueryDeifinition column provides the M script.
Bug fixes
This version also has some bug fixes we had in the Model analysis tab and the Service tab, and few other places.
Your suggestion matters
Power BI Helper is a tool for you and every Power BI Developer. Help us making it better everyday with your suggestions and ideas.
Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
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.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.