Power BI DirectQuery can have performance implications. Bob Ward shares his knowledge to help make SQL Databases perform better! Automatic tuning: https://docs.microsoft.com/azure/sql-database/sql-database-automatic-tuning ColumnStore Indexes: https://docs.microsoft.com/azure/sql-database/sql-database-in-memory Forced parameterization: https://docs.microsoft.com/sql/relational-databases/performance/specify-query-parameterization-behavior-by-using-plan-guides?view=sql-server-ver15 Intelligent Query Processing: https://docs.microsoft.com/sql/relational-databases/performance/intelligent-query-processing?view=sql-server-ver15 PolyBase: https://docs.microsoft.com/sql/relational-databases/polybase/polybase-guide?view=sql-server-ver15