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

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi , dvp 

Sorry I can't fix it on my side,it is recommended to open a support ticket to let engineers look into the issue on your side.

 

 

Best Regards,
Community Support Team _ Eason