Transform List into rows best approach

Hi mcantos ,

Thanks for reaching out to the Microsoft fabric community forum.

lbendlin 

Thanks for your prompt response

For reference, I have included the learning document and previously solved threads, which may help you resolve the issue.

Solved: Re: Normalising nested json data - Microsoft Fabric Community

Solved: Transform Data, List into individual rows - Microsoft Fabric Community

Json.Document - PowerQuery M | Microsoft Learn

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

If this post helped resolve your issue, please consider the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana.