Generate a DATA DICTIONARY in Power BI with HIERARCHY!!!

[@Noxxolotl]

This video has been extremely helpful and easy to follow! I do have a question: For the Description Matrix, if I add a description to one of the measures, will it update in the dictionary, or do I need to refresh it somewhere?

[@PowerBIBro]

Thank you for sharing and I’m happy to hear you find it helpful!! For the description field, after you enter in a new description, then you’ll need to click “refresh all” and it will refresh all the info.view tables and the dictionary, then it will show up!

[@berec52]

This is amazing. I've been working on a Dictionary using Dax Editor. Thank you for sharing!

[@PowerBIBro]

Glad you love it and thanks for your support! Please share with your friends and coworkers!

[@nay4n]

Great tutorial thank you. Just a tip, when editing your measures where there are multiple references to change (in this example the 05 to 07 for the Dictionary table reference) just click the first instance then press Ctrl + Shift + L and it will mass select all so you only need to update it once.

[@PowerBIBro]

Happy to hear you think the tutorial is great, and thank you for sharing the Ctrl + Shift + L shortcut!!! My mind is blown by that efficiency gain, so cool!!

[@RobertoStaltari]

The quality of the content on this channel is always outstanding, and this video is no exception. However, I do have some reservations about the practical use of this approach. I find myself wondering in which scenarios exposing the 'bones' of the model to end users would be beneficial. I'd love to hear more thoughts on the practical applications of this method.

[@PowerBIBro]

Thank you for this compliment and I love that you find the content outstanding! For a practical application, this is most utilized when you publish semantic models in your service for other people to connect to analyze data or build reporting. Example.. a finance team of 20 people all connect to a single published semantic model to analyze data and build reporting. Data dictionaries like this will allow them to self-serve knowledge vs having to reach back out to developer to understand the purpose/description of field or specific calculation logic. Would love to hear other ideas as well!

[@GrittyDuckGrin]

nice instructions will keep them in the back of my mind when i need it.

[@PowerBIBro]

Love it and thanks for sharing!!!

[@HappywithCath]

Thanks for posting this helpful video!

[@PowerBIBro]

My pleasure and thank you for sharing!!

[@walterstevens8676]

Very interesting! So this covers everything that has been brought into a specific report? How you use it to encompass everything that the data is used for, across all reports?

[@PowerBIBro]

Glad you like it!! Yep, it automatically brings in every data element in your semantic model. So if reports share a semantic model than yes, if reports use different semantic models then each would have their own model dictionary. Hope this helps!

[@silaspaul144]

I am finding it difficult to download the practice file from github. Is there any other link where we can download the file? Thanks.

[@PowerBIBro]

Thanks for your question and I'll be happy to help! Confirmed the github link is working as expected, here's a quick overview. Go to the github link for this file below. github.com/powerbibro/powerbibro/blob/main/PBI%20-%2020241102%20-%20Data%20Dictionary.pbix On the right side there is a download icon (arrow facing downwards, two the right of the "Raw" icon). Simply download it by clicking that download icon and you should be all set! Let me know how it goes!