PQ Modelling Practices / Azure DevOps

[Anonymous]

Hi,

Thanks in advance!

[v-stephen-msft]

Hi @Anonymous ,

You could try shape and combine data in the power query editor.

For detailed steps , you can follow : 

Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

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

[Gabriel_Walkman]

I'm not aware of any method to automatically create multiple separate tables / queries.

I'd just reference the table from the state of your screenshot, manually rename and then choose the corresponding table to expand to.