Power BI Helper December 2019 Feature Summary

December 2019 is a major update in Power BI Helper. We believe this is the biggest update we have done so far. The list of updates is big. To name a few, now we have pages, visuals and bookmarks metadata available, visual comparer, visualization tree, the reverse dependency tree, DMV execution page, and dependant calculations for tables and columns with many more features. The layout of the Power BI Helper also had some changes in this version, which we believe would be well received. Let’s see what’s hot and new in the December 2019 version.

This update includes features below:

  • Visualization
    • List of NOT used fields or tables
    • New layout
      • Visualization tab
      • Bookmarks and tables added there
      • Fewer clicks, easier navigation
      • Better look
    • Search enhancement (Bug-fix)
    • Pages metadata (size, filter, order, etc)
    • Visuals metadata (type, custom title, etc)
    • Filter visuals based on pages
    • Filter fields based on pages or visuals
    • Visual/layout comparer
    • Visualization Tree
  • Documentation
    • Documentation of all visuals/pages/files used/not used/bookmarks
  • Modeling
    • Reverse dependency tree
    • Icons in the dependency tree
    • Dependent calculations for tables and columns
    • Relationships metadata
    • DMV Explorer

Read more about features in detail 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 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 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.