The Complete Guide To DirectQuery Mode In Power BI
2022TL; 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.