How to create a data dictionary script to provide to an business user?

Question

Hi all - I'm in somewhat of a unique situation and would ask for some guidance on how to go about this.I'm querying off of a database which has a field called process name, start time, end time, status, and then there's a JSON column which is specific to each process that exists. In Power Query, if I want to double click down on 1 process and see all of the custom dimensions, I have to filter down to only that process name, then parse thre JSON column, and BOOM, easy as that, there it is. JSON column parsed with all custom dimensions that correspond to the process I chose.&nbsp;I've been creating reports with everything EXCEPT the custom dimensions in the JSON column. For the most parts I've made KPIs and Viz's with utilization, success metrics, exception reporting, etc. These are all default logging fields which are easy to work with and present.But I'm noticing that every customer I have, has different processes, and completely different dimension for those processes. I want to somehow be able to create a data dictionary (maybe in a word doc?) that basically would list the column name, and then under the column name (indented maybe), all the possible values in that column (assuming they're strings)..&nbsp;My end goal is to be able to automatically create this report, then give to a client as if it's a menu showing all the different ways we can slice and dice the data based on all available fields and dimensions. I hope this was somewhat clear.&nbsp;My assumption is that maybe it would require some Power Automate and/or Python for something like this? I'd apprecaite any general guidance here. Thx!

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Power Automate is a service that helps you create automated workflows between your favorite apps and services to synchronize files, get notifications, collect data, and more.
&nbsp;
You may try Power Automate visual , with this,&nbsp;end users will be able to run an automated flow, all within a Power BI report. Additionally, the flow executed can be data contextual, which means that flow inputs can be dynamic based on filters set by the end user.
&nbsp;
For more information, please refer to:
New Power Automate Vistual for Power BI Reports
Power BI Automated Reports using Power Automate
&nbsp;
&nbsp;
Best Regards,Eyelyn QinIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Related content

Data Dictionary

Data dictionary

Realtime - Business Events - cannot create business event shcema

Business Requirement Document Template

Power BI Dictionary