Direct Query to SQL Server in Power BI

Understand the pitfalls, design for performance.

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.