Forum Discussion
Solved
How to treat an array structure as a table's field on Power Query
Hello, Everyone. I'm using use the web source on Get Data to submit a JSON request and retrieve data from an app to Power BI. However, in some cases, I retrieve an array structure as one of the t...
First of all, I would like to thank Greg and Maggie for the help. I have followed the Greg's tip and it would work if my data was a normal JSON, but it was a multidimentional JSON. I need to parse it. I have found an article here in Community, but on the Desktop Forum that is exactly my case (https://community.powerbi.com/t5/Desktop/Unable-to-figure-out-how-can-i-make-Multidimension-JSON-Nested/td-p/324041). I saw the YouTube video and it is sound very complex to my Power BI knowledgement, but I will try.
Thanks again for your help.
Regards.
Greg_Deckler
Community Champion
Community ChampionThat should be a Table that you could then expand.