cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
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
Pablo Fernandes
Microsoft

‎06-30-2019 08:13 AM - last edited on ‎07-12-2019 11:26 AM by

‎06-30-2019 08:13 AM - last edited on ‎07-12-2019 11:26 AM by

Dynamic Data Dictionary

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

91 Views
0 Likes
0 Replies
Reply
Related Conversations
flashing a white screen while open new tab
 cntvertex in Discussions on 10-05-2019
13 Replies
Tabs and Dark Mode
 cjc2112 in Discussions on 09-18-2019
22 Replies
Stable version of Edge insider browser
 HotCakeX in Discussions on 10-12-2019
35 Replies
What is Canary ring in Windows insider program? and how do we get them?
 HotCakeX in Windows Insider Program on 09-27-2019
9 Replies
How to Prevent Teams from Auto-Launch
 chenrylee in Microsoft Teams on 06-27-2019
28 Replies
PacketMon Components are not loading in WAC 1909
 HotCakeX in Windows Admin Center on 09-24-2019
2 Replies