Forum Discussion

Icon for Helper I rank

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

Anonymous

Not applicable

9 years ago

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
Helper I
9 years ago

This issue I am facing on desktop.
- ashutosh
  Helper 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]'.'
- ashutosh
  Helper I
  9 years ago
  Anyone, has solution for my query? Please.
  - 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
- Anonymous
  Not applicable
  9 years ago
  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

Related content