Forum Discussion
Parsing multilevel JSON feed into PowerBI table 2
Hello, I am trying to parse a JSON that has multiple lists of values that needs to be transformed to cells/columns. A sample of the JSON could be obtained at https://shop.etudewines.com/ewinerysolu...
v-sihou-msft
Microsoft Employee
Microsoft Employee
In this scenario, if you want to extract values from each list and crossjoin the Name column, you just need to expand the Value column into New Rows.
Regards,
Hi v-sihou-msft, Thank you for the reply.
Expanded columns are giving me key-valuespairs as column cells; I want to transform the first column into headers and expand lists to columns (each list contains values, each list has the same length).
Here is an example of what I am trying to get: