Ever wondered how to make your data reporting faster and more efficient? In this demo-based session, I will show you how to implement live-data reporting using Direct Lake. Based on a real-world example, I'll demonstrate how we transformed a direct query solution to Direct Lake, accelerating our project reporting. Additionally, I'll reveal how we combined traditional and cutting-edge technologies to provide the best user experience. At the end, we'll compare the old and new reports to experience the performance difference live.

This session aims for attendees with an understanding of data reporting and are eager to delve deeper into it. We will cover specific technologies (SSIS, Power BI, SQL Server, Azure SQL DB, Mirroring, and Fabric Lakehouse) and their integration.

At the end of the session you will know:
• How to ingest on-prem data to Fabric in near real-time
• Key limitations of Direct Lake and how to mitigate them
• Is Direct Lake really faster than direct query? :-)

If you want to create blazing-fast and constantly up-to-date reports in Power BI, this session is for you. Join us and take your data reporting to the next level!