Power BI Model Documenter v2

Back in 2020, I released the first version of the Power BI external tool to document your Power BI data model. Since then, I wrote a lot about this topic, such as why adding descriptions to everything is important and various releases of the model documenter.

Users encountered various challenges with the initial release of the tool. I tried to help everyone to my best knowledge, but some issues kept coming back. Over the past period, I worked together with my colleague Ton Swart to solve all these challenges in a new updated version!

Today, I’m overly excited to announce version 2 of the Power BI Model Documenter!

In this blog you will read more about the new version, the enhancements, where and how you can get it.

In case you directly want to get your hands on it, you can easily download the installer using the button below.

Focus of the Model Documenter

The Power BI Model Documenter is primarily focused on documentation purposes. The tool will only extract information that is part of your data model. This is done by taking benefit of the VPAX file extension, which includes meta data of Tabular Models.

A few minor elements that are flagged in red in the Model Documenter, only relate to missing descriptions (which are key to documentation) or potential risks in relationships which can lead to ambiguity or limited relationships.

If you are looking for cleaning up your solution or suggestions for improvements of your data model, I encourage you to have a look at Power BI Cleaner built by Imke Feldmann.

The before and after of Model Documenter

With Model Documenter v2 we take a massive step forward by solving a bunch of common challenges! Now, Model Documenter has an easy next-next-finish installer which helps you to put the files in the right location. Also, the entire backend of the tool has changed to be more reliable and avoid common encountered challenges. A massive shout out to Ton Swart for helping out with rebuilding!

Previous challenges with Model Documenter v1

Previous challenges are listed below:

  • Installing the external tool was a pain, as manual changes in the Program Files folder were required.
  • Model documenter v1 used PowerShell on the backend, where Execution policies were conflicting with organizational policies which prevented usages for some folks.
  • Model documenter v1 used Dynamic Management Views (DMVs) to read metadata from the model on local host. This run through the OleDB connector which executed SQL queries. By executing native queries in SQL, some users had to approve every single query run in Power BI (due to local Power BI settings).
  • Model documenter v1 caused issues with loading the data due to privacy level configurations in the local Power BI instance.
  • Model documenter v1 was only able to read from local host data models in Power BI Desktop.

New in Power BI Model Documenter v2

New in Model Documenter v2 is:

  • Easy next-next-finish installer to put the files in the right location on the computer.
  • New and enhanced backend of the tool, which is not relying on DMVs nor PowerShell anymore.
  • Ground-up rebuild model documentation Power BI Template file, to present all information in a report.
  • Support for live connected Analysis Services models, or through XMLA endpoint connected Power BI Premium datasets. (Live connected Power BI datasets are not yet supported)
  • No longer pop-up windows to allow native query execution.
  • No more failing loads due to privacy levels 
    (Note: Ignoring privacy levels improves Model Documenter run time).
  • Deprecation of the Excel model documenter report. Going forward, only Power BI report will be supported.

Resources

The Model Documenter comes with a bunch of resources. Below a list of resources that could come in useful:

2 thoughts on “Power BI Model Documenter v2

  1. Pingback: Power BI Model Documenter v2 – Curated SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s