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.
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)..
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.
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!
