22-25 April 2026
Video unavailable
SQLBits 2022

The Complete Guide To DirectQuery Mode In Power BI

Learn how DirectQuery mode works in Power BI, how to tune it and when you should use it.
DirectQuery mode in Power BI sounds great: why spend time importing data when you can just get Power BI to generate SQL queries to fetch data for your report when it is rendered? It's not always that simple though. In this session you'll learn how Power BI works behind the scenes (including several details that are undocumented), how you can tune your datasets and reports using features like aggregations and hybrid tables, and most importantly when you should consider using it and when you should not.