Forum Discussion

Katerina_SL's avatar
Katerina_SL
Helper II
2 years ago

hstore import

Hello everyone!

 

Could you please help me with importing hstore data into power bi?

I know that power-bi doesn't support this type of data and I saw another messages in this forum. But they wasn't solved.

I would be approciate very much if somebody will share with me workaround how to do it. I believe that it's possible.

 

Thanks a lot,

Ekaterina

Need Help
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Katerina_SL ,

    Just as you mentioned, Power BI does not support this type of data, so I think you can  convert hstore data into a JSON format, because Power BI has better support for JSON.

     

    When you have your data in JSON format, you can use Power Query in Power BI to import and transform this data. In Power BI Desktop, go to "Home" > "Get Data" > "More..." > "Other" > "Blank Query".

    Use the Power Query Editor to connect to your database and run the query that outputs your data in JSON format.Use the "From JSON" functionality in Power Query to parse the JSON data into a table.

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Katerina_SL's avatar
      Katerina_SL
      Helper II
      2 years ago

      Hello! Thank you for your reply!

      Could you please write more details how can I "Use the Power Query Editor to connect to your database and run the query that outputs your data in JSON format.Use the "From JSON" functionality in Power Query to parse the JSON data into a table."

       

      Thank you,

      Ekaterina