Forum Discussion

ashutosh's avatar
ashutosh
Icon for Helper I rankHelper I
9 years ago

Hstore value giving error in Power BI

I have hstore values in my table (postgres), when I am uploading this table in the Power BI values in the column are either null or Error.  I am getting this error for the error values DataSource.Err...
Need Help
ashutosh's avatar
ashutosh
Icon for Helper I rankHelper I
9 years ago

 

This issue I am facing on desktop.

ashutosh's avatar
ashutosh
Icon for Helper I rankHelper I
9 years ago

I have column which has values in hstore data type in postgres sql. When I get the data from the table these values are not showing in the Power BI. I am getting 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]'.'