Forum Discussion

349624222's avatar
349624222
New Member
7 years ago
Solved

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

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