Forum Discussion

dvp's avatar
dvp
Helper I
5 years ago
Solved

Azure Data Explorer / Kusto with dynamic column

I have the following function in ADX/Kusto:   .create-or-alter function with (docstring = "Customers View",folder = "Views") CustomersTest {     datatable (CustomerId:string, StateReasons:dynamic...
Need Help
  • dvp's avatar
    dvp
    5 years ago

    There seem to be 2 solutions to the issue:

     

    1) Replace

     

     | extend StateReasons[0], StateReasons[1]

     

    with 

     

     | extend tostring(StateReasons[0]), tostring(StateReasons[1])

     

    in the function

     

    2) Add a Data Transformation step in Power BI Desktop and set the data type of the 2 columns to Text ...

dvp's avatar
dvp
Helper I
5 years ago

There seem to be 2 solutions to the issue:

 

1) Replace

 

 | extend StateReasons[0], StateReasons[1]

 

with 

 

 | extend tostring(StateReasons[0]), tostring(StateReasons[1])

 

in the function

 

2) Add a Data Transformation step in Power BI Desktop and set the data type of the 2 columns to Text ...