Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Katerina_SL
Helper II
Helper II

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

3 REPLIES 3
v-yilong-msft
Community Support
Community Support

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

vyilongmsft_0-1709884597142.png

vyilongmsft_1-1709884741807.png

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.

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

Greg_Deckler
Super User
Super User

@Katerina_SL Are you referring to this thread? Hstore value giving error in Power BI - Microsoft Fabric Community


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.