Meinrad Weiss
Microsoft, Senior Cloud Solution Architect Data&AI
Bring light to the darkness and answer the question: Which house should you choose for your gold layer?
In the evolving landscape of Microsoft Fabric, selecting the optimal house for the gold layer and the right semantic model connection mode—Import, Direct Lake, or DirectQuery—can feel like navigating a maze. This session sheds light on the performance and functional implications of each option by benchmarking Power BI queries. Using a dynamic notebook, we execute consistent Power BI queries across multiple models to evaluate runtime performance under various conditions, including Row-Level Security (RLS) applied at different levels (fact table, small dimension, large dimension). What you’ll learn: Decision drivers for each house (Warehouse, Lakehouse, Eventhouse). Strength and weakness of the different Power BI connection modes (Import, DirectQuery, Direct Lake). Pros and Cons for RLS in SQL Endpoints and Semantic Models. How to dynamically execute and trace Power BI queries for performance benchmarking. Whether you're optimizing for query speed, scalability, latency, or security, this session will help you make informed, data-driven decisions about your gold layer architecture in Power BI.
About Meinrad Weiss
With nearly two decades of experience at Trivadis as a consultant in the data space, Meinrad has honed expertise in SQL Server, OLTP, and analytical databases. Proficient in relational, multidimensional cubes, and tabular models, Meinrad was an early adopter of Microsoft Azure and its related data services. A regular speaker at local conferences, he transitioned to Microsoft seven years ago as a Senior Cloud Solution Architect. In this role, Meinrad focuses on data projects, primarily analytical and IoT solutions using Microsoft Fabric. Additionally, Meinrad possesses a strong understanding of ADF pipelines and semantic models, having developed several frameworks to automate data ingestion pipelines.