Forum Discussion

Katerina_SL's avatar
Katerina_SL
Helper II
2 years ago

error don't support CLR type

Could you please help me with this error?

 

DataSource.Error: An error happened while reading data from the provider: 'We don't support CLR type 'System.Collections.Generic.Dictionary`2[System.String,System.String]'.'

 

I have this error in one of columns after import data from database to power bi. It has dictionary type.

 

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Katerina_SL ,

     Hello, your problem is that during the import of data from the database to Power BI, the error is caused by the presence of dictionary type data in the database data.

     

    I checked the official documentation and found that Power BI doesn't support dictionary-type data.

     

    Here is the link to the documentation.

    Data types in Power BI Desktop - Power BI | Microsoft Learn

     

     

    Best Regards,

    Jayleny

     

    • Katerina_SL's avatar
      Katerina_SL
      Helper II
      2 years ago

      Thank you for reply. Do you maybe know some workaround, how can I import this data?

      • alexTaran's avatar
        alexTaran
        Frequent Visitor
        2 years ago

        Katerina, hi,

         

        Have you solve this issue? Have the same trouble. 

  • Katerina_SL's avatar
    Katerina_SL
    Helper II
    2 years ago

    Hello everyone, I would like to ask if it exists some workaround how to import this type of data to power bi. I think it's strange not to have this possibility.