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.

 

Related content