An abbreviated look at Power BI Document Generation Solutions – Power BI HelperData
In the first blog of this series, An abbreviated look at Power BI Document Generation Solutions – Model Documenter we explored the document generation features of Data-Marc’s Power BI Model Documenter. The other noteworthy contender in this arena is RADACAD’s Power BI Model Documenter, within the Power BI Helper suite (Download).
Power BI Helper is a virtual Swiss Army knife when it comes to its collective Power BI capabilities.
Amongst the features Power BI Helper offers are:
- Performance tuning
- Model, visualisation and Power Query metadata documentation
- Power BI Service integration
- Power BI file comparison
- Power BI files and model cleansing.
In this blog we will focus solely on Power BI Helper’s Model Analysis and document generation features. After Power BI Helper has been downloaded and installed, it can be launched by selecting the Power BI Helper link via the Power BI inbuilt External Tools menu item in Power BI Desktop.
This opens the Power BI Helper Model Analysis Tab where a connection to a Power BI file can be initiated. It will default to the current model, if launched from an existing PBI solution.
Power BI Helper then automatically populates the Table, Column and Measures widgets with the solution metadata. The Model Analysis tab with data from Microsoft’s Artificial Intelligence Sample.pbix sample is shown in the screenshot below.
Clicking any item in the top-level data grid widgets will drill into its underlying detail in the Expression and Dependency widgets below it. Note that this filtered perspective of the model is not reflected in the solution document generated output – selected from the Export to Document button in the upper right-hand corner.
The documentation tab enables configuration of the styling and formatting options (left-hand pane), as well as the specific content areas to be included in the documentation (right-hand pane).
Clicking the Create Power BI file’s document button presents you with a Save As modal screen where you can assign the path and name for the generated document. Note that only .htm file types are output.
Document generation may take time depending on the selected Options but will usually result in the successful export screenshot below.
The generated .htm file provides basic tabular representations like the selected Options.
- List of Pages
- List of Bookmarks
- List of all Columns/Fields/Measures/Expressions Used in Visuals
- List of Tables Used in Visuals
- List of Columns Not Used in Visuals
- List of Tables
- List of Measures
- List of Columns for Table
- List of Roles
- M (Power Query) Script
Below screenshots of the related tables available in the document generation Options screen. Similar tabular representations of the other tables are also available when selected.
List of pages
List of Table for Visuals
List of columns for calendar table
Similar tabular representations of the other select Options are also detailed in the document .
If any post processing is required then the generated htm tabular data can be loaded into Excel using Power Query via the Data->From Web or Get Data -> From File -> From XML menu options.
In summary Power BI Helper provides several handy options to document a Power BI solution. Both a Power BI Desktop or Power BI service context can be used to document, validate, conform, and potentially version control the Power BI solution. Note that documentation is only one aspect of this multi-purpose tool whose other features deserve further examination. Overall, Power BI Helper is a valuable addition to your toolbox.