Direct Query to SQL Server in Power BI
2022TL; DR
Understand the pitfalls, design for performance.
Session Details
Understand how Direct Query works through to SQL Server from Power BI with the aim of getting the best performance and lowest resource usage. The session will cover pitfalls and design suggestions, you'll see how to troubleshoot problems and get the benefits of real-time reporting and farming out some of the load back down into your Relational database.