#directlake

Hands On : Build a Direct Lake Model with Data Agents with 275M+ Healthcare Records

This solution demonstrates the capabilities of Microsoft Fabric using over 275 million rows of real-world healthcare data. It showcases how to leverage the Power BI Direct Lake connector to query large datasets stored in Delta Parquet format—without caching or a relational database. Fabric Data Agents have also been added for the Semantic Model and the Lakeouse or Warehouse. The Semantic Model is also optimized for Power BI Copilot, including the standalone version that functions as a SaaS MCP server for chatting on all of your content and data. The dataset used is the publicly available Medicare Part D Prescribers - by Provider and Drug, sourced from the Centers for Medicare & Medicaid Services (CMS). 🎥 Watch the full demo: YouTube Video https://youtu.be/2tLIGVZ4c8E