Rows to Columns - Unnest Nested JSONs

[xinxilas]

Hello Friends

May i Have some Help?

I have nested JSON files, im trying to transform Rows -> Column to unnest the table again

Here is a pic: 

https://i.ibb.co/MPyFgjv/unnest.jpg

Any tip? 😕

[xinxilas]

I tried to Pivot Columns(atributes id as Column, and atributes names as values), but i recieve this error:

https://i.ibb.co/3THNFgW/image.png 

[dax]

Hi xinxilas,

It seems that the operator can't work on List, you might need to modify it. But I couldn't know, what expression you use in M code cause thie problem, so if possible, could you please inform me more details information(such as your sample code and your expected output)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.