Slides
Slides for the talk Under the Covers with Power BI, Experts Live AU, Sydney, Oct 19-20 2023.
Links
https://www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/
Delta Lake table optimization and V-Order - Microsoft Fabric | Microsoft Learn https://learn.microsoft.com/en-us/fabric/data-engineering/delta-optimization-and-v-order
Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/dn393915(v=msdn.10)
Data reduction techniques for Import modelling https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
Best practice rules to improve your model’s performance https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/
Useful Tools
DAX Studio https://daxstudio.org/
Bravo https://bravo.bi/
Tabular Editor https://www.sqlbi.com/tools/tabular-editor/