Home
Home
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

71 Views
0 Likes
0 Replies
Reply
Related Conversations
How to Prevent Teams from Auto-Launch
 chenrylee in Microsoft Teams on 06-27-2019
25 Replies
Early preview of Microsoft Edge group policies
 Sean Lyndersay in Discussions on 06-14-2019
64 Replies
*Updated* Syncing in Microsoft Edge Preview Channels
 Elliot Kirk in Articles on 05-01-2019
155 Replies
This form can't be distributed as it is asking for personal or sensitive information
 NZLaSalle in Microsoft Forms on 07-19-2019
52 Replies
Microsoft Office 2019 Now Available – Comparing 2019 🆚 2016 🆚 365, New Features in Access & Excel
 Dan Moorehead | PowerAccess in Access on 09-24-2018
13 Replies
Teams Calling - Dial pad missing
 Chris Cooper in Microsoft Teams on 03-26-2019
71 Replies