Power BI Helper

Download Free Here

Download Power BI Helper from here:

What Power BI Helper version July 2019 Does?

This version of the tool will give you these features

• All NOT working DAX Measures
• Export data tables into CSV files
• Getting all Apps information from service and documenting it
• Getting all Gateways, Data Sources, and service configurations and documenting it
• Some enhancements and more information available from Tables, Columns, and Measures

To learn more about this version, read this blog post.

What Power BI Helper version April 2019 Does?

This version of the tool will give you these features

• XMLA endpoint Connectivity
• Connecting to Power BI objects (workspaces, dashboards, datasets, reports, dataflows) in the service
• Documentation of all Power BI objects in the service
• Downloading a version of all Power BI reports (PBIX files) from all workspaces to a local folder
• Publishing Power BI files to multiple workspaces
• Copying content from one workspace to another!

To learn more about this version, read this blog post.

What Power BI Helper version November 2018 Does?

This version of the tool will give you these features

• Column Sizes for Performance Tuning
  • revealing the column sizes in the model
• Bookmarks and Pages
  • Find Bookmarks belong to each page
  • Find pages associated with each bookmark

To learn more about this version, read this blog post.

What Power BI Helper version 4.0 Does?

This version of the tool will give you these features

• Beautify M Script
• Row-Level Security in the Analytics Tab
• Export the documentation above

To learn more about this version, read this blog post.

What Power BI Helper version 3.0 Does?

This version of the tool will give you these features

• Export the Model documentation including
  • all tables
  • all measures and their expressions
  • all columns in each table (including calculated columns and their expressions)

To learn more about this version, read this blog post.

What Power BI Helper version 2.0 Does?

This version of the tool will give you 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

To learn more about this version, read this blog post.

What Power BI Helper version 1.0 Does?

This version of the tool will give you these features

• Export M/Power Query Script
• Search based on field/table/measure name or properties
• Runs on Virtual Machines

To learn more about this version, read this blog post.

What Power BI Helper version 0.3 Does?

This version of the tool will give you the expression tree of DAX measures

• Measure Dependency Tree
• List of all tables, columns, and measures in a Power BI Model

The feature of searching makes understanding the Power BI Model much easier. It will help new developers in your Power BI project to get along with your model and report faster, rather than spending lots of time and money to get familiar with it.

To learn more about this version, read this blog post.

What Power BI Helper version 0.2 Does?

This version of the tool will give you three information related to the search term;

• Is there any Report Level Filter for this field or table
• List of all report pages that this field or table used in their “Visual” fields.
• List of all report pages that this field or table used in their “Page Level Filter”

The feature of searching makes your documentation part easier. It will help new developers in your Power BI project to get along with your model and report faster, rather than spending lots of time and money to get familiar with it.

To learn more about this version, read this blog post.

What Power BI Helper version 0.1 Does?

This product is still in version 0.1 (means the very first version); This tool helps in below scenarios;

• Identify fields that are used in the Fields section of visualizations
• Identify tables that are used in the Fields or Filter sections of report tab

Providing such result then will help you to hide extra tables from the report. Or even remove them (this part needs some extra manual investigation as of now).

To learn more about this version, read this blog post.

Upcoming Features

For the very first version; We have many limitations! These limitations will be lifted in future versions. Some of these limitations which will be added as a feature in next versions of Power BI helper are;

• List of fields used in the Filter area
• List of tables or fields used to create a calculation (calculated table, column, or measure)
• List of tables or fields used to create a relationship to other tables
• Details of what fields or tables used in a specific report or visual
• Diagram view and dependency view of reports and visuals with tables and fields from the model