Power BI on Microsoft Fabric: Lakehouse to Reports

Learn Fabric from a Power BI perspective: Lakehouse setup, Dataflow Gen 2, Direct Lake and Semantic Models and much more

Learn Microsoft Fabric through a Power BI lens. Build a Lakehouse, prepare data with Dataflow Gen 2, design Starschema/Snowflake semantic models, create reports (including paginated), use Direct Lake/Direct Query, automate with Taskflows, and apply local semantic model extensions.

Power BI on Microsoft Fabric: Lakehouse to Reports focuses on how Power BI professionals can work effectively in Microsoft Fabric. You’ll set up a Lakehouse, prepare and transform data with Dataflow Gen 2, design Starschema and Snowflake semantic models, create Power BI reports (including Paginated Reports), select and optimize Direct Lake and Direct Query connection modes, automate processes with Taskflows, and use Local Semantic Model Extensions for advanced relationships such as many-to-many.

What You’ll Learn

• Set up and manage a Lakehouse for efficient data storage and access.

• Build repeatable data prep with Dataflow Gen 2.

• Design Starschema and Snowflake semantic models for robust analytics.

• Create Power BI reports and paginated reports inside Fabric.

• Choose between Direct Lake and Direct Query and understand trade-offs.

• Automate processes with Taskflows.

• Use Local Semantic Model Extensions for advanced relationships (e.g., many-to-many).

Who Is This For
Power BI developers and data professionals who want to learn the new Microsoft Fabric platform and use Power BI effectively within Fabric as they develop their analytics careers.

Topics Covered

• Lakehouse setup and management

• Dataflow Gen 2 for preparation and transformation

• Starschema & Snowflake semantic model design

• Power BI report creation, including paginated reports

• Connection modes: Direct Lake and Direct Query

• Taskflows for process automation

• Local Semantic Model Extensions and many-to-many relationships