Forum Discussion
Append multiple fact tables vs different fact tables
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,
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.
4 Replies
- JorgePinho
Solution Sage
Hello Chrisj !
The best practice would be to append them and have a column that indicates the brand of each line 🙂
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
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.
v-jialluo-msftCommunity Support
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
