Forum Discussion
Multi dimensional JSON file to one flat table
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,
ImkeF has provided a detailed solution about this issue in the similar thread below, please add a custom column in your query following her guide and then expand the custom column.
http://community.powerbi.com/t5/Desktop/Expand-column-where-not-all-records-are-tables/td-p/79060
Regards,
Lydia
Thanks Lydia. I tried this solution but got an error message when trying to apply it:
Expression.Error: We cannot convert a value of type Table to type List.
Details:
Value=Table
Type=Type
Anonymous,
Could you please post the JSON code so that I can test?
Regards,
LydiaHi 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.