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.