Forum Discussion

ramankr48's avatar
ramankr48
Helper 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
Community 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