topic Re: Help flattening Json in DAX Commands and Tips

Help flattening Json

Anonymous — Thu, 20 Aug 2020 06:18:58 GMT

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

Re: Help flattening Json

amitchandak — Thu, 20 Aug 2020 06:48:53 GMT

Anonymous , refer if these can help

https://www.youtube.com/watch?v=ipI6mrWLQKA
https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/?gclid=EAIaIQobChMI7Za92YSi6wIVFSQrCh0vDgIgEAAYASAAEgLd5_D_BwE

Re: Help flattening Json

Anonymous — Thu, 20 Aug 2020 07:39:48 GMT

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)