cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chrisj
Regular Visitor

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, 

1 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.

View solution in original post

4 REPLIES 4
v-jialluo-msft
Community Support
Community 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

JorgePinho
Solution Sage
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? 

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.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.