Forum Discussion
Multiple queries transformations VS one big query transformation
For your scenario in Power Query, in my opinion the most efficient approach would likely be to combine the tables first and then unpivot the combined table since you want to reduce redundant transformations across multiple tables.
You can start by combining tables by folders using Table.Combine, performing initial transformations such as removing unnecessary columns on these combined tables.
Once the data is combined and cleaned, use Table.Unpivot to transform it into the desired format.
For your scenario in Power Query, in my opinion the most efficient approach would likely be to combine the tables first and then unpivot the combined table since you want to reduce redundant transformations across multiple tables.
You can start by combining tables by folders using Table.Combine, performing initial transformations such as removing unnecessary columns on these combined tables.
Once the data is combined and cleaned, use Table.Unpivot to transform it into the desired format.