22-25 April 2026

Direct Query to SQL Server in Power BI

2022

TL; 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.

3 things you'll get out of this session