Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |