Read dynamic data type from kusto data source under direct query mode

[349624222]

How to Read dynamic data type from kusto data source under direct query mode?

kusto supports dynamic data type. Now I have a kusto data source table and a dynamic data type column named "customDimensions". Below are some examples. The keys of customDimensions (e.g., status, build_strategy) are not constant and change with different data.

My job must be in the directly query mode (data should be refresh every 30 minutes), But now I couldn't find a way to access the inner data of "customDimensions" in the powerBi desktop (like acess customDimensions.phase as shown in the second picture).

[v-chuncz-msft · Accepted solution]

@349624222 

Here is a similar idea, you may leave a comment and vote it up.