Multiple Tables or mERGE tables in Power Query

[Peter083]

Hi, can someone please help or point me in the right direction for the following:

I have to import 6 tables with transactions from 6 different SQL databases. Each table has exactly the same headings. Before I can use these tables I have to unpivot the same columns in each of the tables.

My question is, is it better to have 6 different transaction tables with similar measures linked to a single calendar table or should these tables be appended to one another. Is there a sound argument for either of the methods ?

Thanks

P

 

[Matt Allington]

Definitely append the 6 tables into 1. Reasons include
1. Better compression
2. Less measures to write
3. Less relationships to propagate = more performant.

Join the 6 tables into one in Power Query, then unpivot them all at once.

 

[Peter083]

Thanks Matt, appreciate your insights they make sense