Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Quick Question, Would it be better for performance to create measures from columns in multiple table or is it the same as creating the measure calculation using multiple table?
for clarification by single table I'm referring to creating a View in SQL containing all the columns to be used from the multiple table and importing that table into the Model.
and by multiple tables I mean leaving the model as is and creating the measures themselves using the all the tables required?
Solved! Go to Solution.
@Euro0681 The generally accepted best practice is that a star schema provides better performance than a single flat table. Data Modeling for Power Pivot and Power BI - P3 Adaptive
@Euro0681 The generally accepted best practice is that a star schema provides better performance than a single flat table. Data Modeling for Power Pivot and Power BI - P3 Adaptive
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 17 | |
| 9 | |
| 8 | |
| 7 |