Append multiple fact tables vs different fact tables

[Chrisj]

Hello all, 

Here is my case:I have multiple fact tables with exactly the same variables for each fact tables but I have 1 fact table per brand. Is it easier to append them all in one  long table or to keep them separated?

For example, in the Sprite table, I have the following columns : year, Month, Days, Price

Same for Coca-Cola, Fanta, etc.... 

What is the most efficient way?

Thank you, 

[v-jialluo-msft]

^{Hi @Chrisj ,}

^{In fact, merging tables is just a simple transformation that doesn't have a significant impact on the efficiency of Power BI.}

^{Best Regards,}

^{Gallen Luo}

[JorgePinho]

Hello @Chrisj !

The best practice would be to append them and have a column that indicates the brand of each line 🙂

[Chrisj]

Knowing these tables are being refreshed every month from a folder and new data are coming in these tables every month, in terms of efficiency when the app is uploaded in the intranet of a company, would it not slow down the app? 

[JorgePinho · Accepted solution]

I think it will be better the way I said. You create just one table and disable the load of the others into the data model.