Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

OLE DB or ODBC error: [Expression.Error] We cannot convert the value "<>" to type Table..

Hello Experts,   I am getting data from cosmos db into powerBI. I see some columns, e.g. Document.status having mixed type of data as shown below: Some rows show List, some has string values ...
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    You can use try/otherwise.

     

    In this case, this should work:

     

    = Table.TransformColumns(#"last step",
    {{"column", each try Combiner.CombineTextByDelimiter(";")(List.Transform( _ , each [value]))
    otherwise null, type text}})

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You can use try/otherwise.

 

In this case, this should work:

 

= Table.TransformColumns(#"last step",
{{"column", each try Combiner.CombineTextByDelimiter(";")(List.Transform( _ , each [value]))
otherwise null, type text}})

 

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Has your issue been solved? If so kindly mark my answer as a solution to close the case. Thanks in advance. Any other question, feel free to let me know please.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-frfei-msft. Would it be possible for you to include the complete code and proper syntax please? I a have a similar issue, but being a newbee to Power BI I am finding the code a little hard to follow. Thanks

Related content