Forum Discussion
How to treat an array structure as a table's field on Power Query
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.
Community SupportHi CEGOS14
After connect to the web source succefully, what result do you get in Power BI(Power query)?
Could you show a screenshot?
Is the Json code above from the web source or something you wanted finally?
Here are some reference how to get json data with Power BI.
https://community.powerbi.com/t5/Desktop/JSON-data-from-a-web-service-call/td-p/245938
Best Regards
Maggie
Hi, Maggie. Before to send the screenshots, I will try to expand the columns, as suggested by Greg. If the problem persist, I will send some screenshots. Thanks for your help. I will bring news soon.
Regards.