Home

Dynamic Data Dictionary

%3CLINGO-SUB%20id%3D%22lingo-sub-730204%22%20slang%3D%22en-US%22%3EDynamic%20Data%20Dictionary%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-730204%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHow%20can%20I%20create%20an%20automated%20data%20dictionary%20out%20from%20Excel%20%2B%20Power%20Query%20%2B%20Power%20Pivot%3F%20I%20see%20in%20power%20pivot%20the%20option%20to%20add%20descriptions%20to%20measures%20but%20don't%20know%20how%20to%20use%20it%20to%20generate%20a%20data%20dictionary.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMy%20current%20workflow%20is%3A%20I%20build%20the%20measures%20and%20everything%20in%20Excel%2C%20publish%20to%20a%20Power%20Bi%20Service%20and%20then%20pull%20this%20PBI%20Service%20from%20Power%20BI%20Desktop%20to%20build%20my%20views%20and%20re-publish.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethanks%20so%20much!%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPablo%20Fernandes%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-730204%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Pablo Fernandes
Microsoft

Hi,

 

How can I create an automated data dictionary out from Excel + Power Query + Power Pivot? I see in power pivot the option to add descriptions to measures but don't know how to use it to generate a data dictionary. 

 

My current workflow is: I build the measures and everything in Excel, publish to a Power Bi Service and then pull this PBI Service from Power BI Desktop to build my views and re-publish.

 

thanks so much! 

Pablo Fernandes

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies