Forum Discussion
Helper IHstore 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.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]'.'
9 Replies
Hi ashutosh,
Can you share some detail content of your issue? (e.g Screenshots, query...) Does this issue appears on desktop or service?
Regards,
Xiaoxin Sheng
ashutoshThis issue I am facing on desktop.
- ashutosh
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]'.'
mgoltsman
can you explain it how we can do in postgres,writing the query based on the particular column1. in pgadmin create SELECT query with params:
SELECT 'a=>1,a=>2'::hstore; hstore
and copy it
2. open power bi
3. click on Get Data button and select postgres
4. input data of connection and click advanced options
5. Paste from clipboard SQL Query
Katerina_SLHelper II
Hello!
I have the same problem.
Have already existed soem workaround for this issue?
And also would like to ask about more details regarding this query (what I need to fill instead of a and so on):
SELECT 'a=>1,a=>2'::hstore; hstore
