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
Prasannakumar's avatar
Prasannakumar
New Member
3 years ago

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's avatar
    Katerina_SL
    Icon for Helper II rankHelper II
    2 years ago

    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