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.
I'm building a model to analyze retail sales, inventory and margin (profit). Each of these are in a separate table organized by week_ending_date, item and location. Currently, the sales table has 6.7M rows, stock has 43.5mm rows, and margin has 58M.
For performance and data model size considerations, I would think that the best practice would be to creating one table/view that consolidates the three areas each on line summarized by date/item/location then connect that view to power bi, rather than bringing in each table separately. This would give me one fact table with 58M rows, rather than three separate tables, each with the same three dimensions, totaling 108M rows.
Would appreciate any thoughts on my my reasoning is wrong and/or suggestions of how to revise my approach. Thank you!
Hi,
For very large data source, i advise you to use 'DirectQuery' connection mode.
Reference:
https://community.powerbi.com/t5/Desktop/organizing-filters-move-Other-to-bottom/td-p/917155
Hope this helps.
Best Regards,
Giotto Zhi
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 |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |