Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
The problem I'm having is that when I expand these tables e.g. in the parent column, it opens them up as another seperate table. See example below:
Is there a way to automatically expand these tables within the original query instead of having each table expand into a new seperate table view?
Solved! Go to Solution.
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.
@LJR,
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
@LJR,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.