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.
Hi All,
I am starting a Star schema data model from a single table and I have this question:
How should I create the dimensions tables? referencing the main table? duplicating it?
I have read some articles but I couldnt find the best approach.
Thanks,
Solved! Go to Solution.
Probably best practice would be to Reference your main query in Power Query editor and remove all unneeded columns. This would be how you would create your dimension tables.
You could also do it in DAX using SELECTCOLUMNS and DISTINCT
Probably best practice would be to Reference your main query in Power Query editor and remove all unneeded columns. This would be how you would create your dimension tables.
You could also do it in DAX using SELECTCOLUMNS and DISTINCT
Thanks, I also found this useful article:
https://radacad.com/performance-tip-for-power-bi-enable-load-sucks-memory-up
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |