Forum Discussion
Multi dimensional JSON file to one flat table
I have a multi-dimensional table from a json source that I'm trying to convert into one flat table. I can expand the columns up to a point, and still have tables within rows as in the below: ...
Hi Lydia
The end solution that worked was to have the json data coming through via an API "flattened" by our developer to provide a simpler table for analysis. I ended up not working with the issue in Power BI as there was another solution in code.
Anonymous,
Could you please post the JSON code so that I can test?
Regards,
Lydia
Hi Lydia
The end solution that worked was to have the json data coming through via an API "flattened" by our developer to provide a simpler table for analysis. I ended up not working with the issue in Power BI as there was another solution in code.