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 , As we haven’t heard back from you, we wanted to kindly follow up to check if the issue got resolved? or let us know if you need any further assistance here?

 

 

 

 

Thanks,

Prashanth Are

MS Fabric community support