Power BI DirectQuery and SQL Databases: A Conversation with Bob Ward

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