Document a Power BI file and report in a few clicks all DAX code visualization Power Query scripts

In this article and video, I’ll share with you how to document everything from a Power BI file in a few clicks. The document output will have all the DAX code (measures, columns, and tables) with the expressions, the tables with the Power Query scripts, information about visualization such as how many pages, bookmarks, visuals in each page, and even what tables or columns used or not used in visualization. All in just a few clicks.
Get the links and learn more from my blog article here:

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********

#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD

[Karenshow]

Oh my God, all I can say is THANKS THANKS, THANKS to the power N. RADACAD you are saving me tone of time. I love it.

[theparin]

Quite an efficient tool! Especially for the business analysts for FRS (Functional Requirement Specification) documentation purposes. Thanks so much!

I kindly make one request: Is it possible to generate a table where the titles of the visuals used in the dashboards are available with the tables and columns used to create them, with the DAX queries used for MEASURES and Calculated columns?

[saimanikantavuppala]

Hi @RADACAD..I am unable to download the tool from the provided link. Could you please help me out?

[sweekrith]

Amazing work, it's so awesome 👍 great work, kudos to you and your team.

[bettina.e-k]

Fantastic! genuinely useful, not least for cleaning up redundant elements -- especially measures. Thank you all for creating such an easy to use tool!

[massimocolaceci]

Thank you Reza for such a deep work and clear explanation. I will provide a feedback.

[VishGaitonde-kmoo]

does this also document the various Sources the Reports use and kind of sources like a DWH, DB via API, Excel sheets etc?

[sailing_life_]

This is great. Do you have any recommendations for how to allow users to access the .html output? We'd have to host that file somewhere right? Like I'm thinking you could have a page in the power BI report that allows the user to click a link and then they can view the HTM file?

[luisfernandomacedo]

Hi! I followed the steps abovementioned, and regarding the list of measures, It came along - all in the same table - with list of columns/fields. Your exmaple it's more readable than mine. All my data comes from Analysis Sevice. Am I missing something? Does it have any limitation?

[magacomentario]

Hi! I want to see the filters at the page level and in the visuals on each page. Is there any way to view this with this external tool?

[nishyt]

I am not able to connect this with model its showing me Object reference not set to an instance of an object.

[garzamalan]

Is there a cap limit to use this solution, I tried it with a small model, it worked fine, I tried it with a large model (45 MB), and it ran all noght and couldnt generate the html ...

[fatjanpaloja]

Great. I have it since summer 2020 as external tool, together with Dax Studio and Tabular Editor.
👍🏻

[garycully]

Hello community, a tool with great promise. Unfortunately, the Visualization tab does not find the file path ...what should I do to help BI Helper find the path ... by the way the .pbix is opened in the same instance as the PBI Helper.

[marathispreads]

the mateiral used in video how we can get ?

[zm]

Hello, just wanted to ask you if this external tool will read information from a power bi desktop file that used an imported dataset (feature used through Data - connect to existing Datasets)? Thanks

[labrador_riku]

pbi helper installed, but it can't see open pbix file, even it's been opened from External tools

[richardcollins]

Sadly the download is rejected by my Win 10 Edge browser not safe 'can't be downloaded securely'

[drac]

Is it just me or there is no option to download from the website?