22-25 April 2026

The Complete Guide To DirectQuery Mode In Power BI

2022

TL; DR

Learn how DirectQuery mode works in Power BI, how to tune it and when you should use it.

Session Details

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.

3 things you'll get out of this session