Hstore value giving error in Power BI

[ashutosh]

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]'.'

[Prasannakumar]

@mgoltsman 

can you explain it how we can do in postgres,writing the query based on the particular column

1. 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_SL]

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

[Prasannakumar]

Hi @mgoltsman

can you give the solution briefly which u shared on the above 

[v-shex-msft]

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

[ashutosh]

This issue I am facing on desktop.

[v-shex-msft]

Hi @ashutosh,

Based on test, current power bi seems not support to direct import hstore type, perhaps you can convert it to text, then import to power bi desktop.

In addition, you can also post this requirement to ideas. 

Regards,

Xiaoxin Sheng

[ashutosh]

Anyone, has solution for my query? Please.

[mgoltsman]

I had problems like yours, but with postgis. 

You can try like this:

1. 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 

I hope this helps you

[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]'.'