Forum Discussion

ramankr48's avatar
ramankr48
Icon for Helper II rankHelper II
1 year ago
Solved

How can I split a variable-depth, slash-delimited path_column field into separate col in KQL?

Q : How can I split a variable-depth, slash-delimited path_column field into separate path_lvl_1, path_lvl_2, … columns in Kusto (Fabric) so that Power BI (in DirectQuery mode) can consume a fixed sc...
eventhouse
kql database
kql queryset
real-time dashboard
  • datacoffee's avatar
    datacoffee
    1 year ago

    Sure thing - just remove the column defintion fret the pivot function. Then the previous query will be dynamic 

v-prasare's avatar
v-prasare
Icon for Community Support rankCommunity Support
1 year ago

Hi ramankr48 , We would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.

 

 

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

 

 

Thanks,

Prashanth Are

MS Fabric community support