Forum Discussion

ashutosh's avatar
ashutosh
Helper 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
Helper I
9 years ago

 

This issue I am facing on desktop.

ashutosh's avatar
ashutosh
Helper I
9 years ago

Anyone, has solution for my query? Please.

  • mgoltsman's avatar
    mgoltsman
    Regular Visitor
    8 years ago

    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