Forum Discussion
Help flattening Json
I am looking for some power query help expanding a json structure into rows. Below shows the data I have so far in power bi and the pours list I need to expand in the last column, plus the raw json results I get via Postmon. Any suggestion are appreciated
2 Replies
- amitchandak
Super User
- AnonymousNot applicable
Hi Anonymous ,
See if this helps.
https://community.powerbi.com/t5/Desktop/Need-help-expanding-JSON-list-in-column/td-p/467072
https://community.powerbi.com/t5/Desktop/Help-with-expanding-nested-json/td-p/352812
https://community.powerbi.com/t5/Desktop/Converting-JSON-data-into-PowerBI-table/td-p/256455
https://community.powerbi.com/t5/Desktop/Expanding-records-from-JSON/td-p/340256
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)