error don't support CLR type

[Katerina_SL]

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.

[Katerina_SL]

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.

[v-jialongy-msft]

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]

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

[alexTaran]

Katerina, hi,

Have you solve this issue? Have the same trouble. 

[Katerina_SL]

Hello!

Here I've got more information but still it's not solved.

https://community.fabric.microsoft.com/t5/Desktop/hstore-import/m-p/3750838#M1217794