Skip to content

v2.0.0 - Rebuild of the Model Documenter

Compare
Choose a tag to compare
@marclelijveld marclelijveld released this 04 Jan 09:08
d8c2eb0

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 @tonswart 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 this version

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 supported yet)
  • No longer pop-up windows to allow native query execution.
  • No more failing loads due to privacy levels (though, ignoring privacy levels improves Model Documenter run time).
  • Deprecation of the Excel model documenter report. Going forward, only Power BI report will be supported.