Microsoft Fabric: Tuning & Performance

Microsoft Fabric Performance Training, Hands-on Learning

This one-day workshop gives data and BI teams a practical way to find and fix performance problems in Microsoft Fabric. You will learn how capacity is consumed and throttled, how to identify the workloads driving cost, and which tuning techniques have the biggest impact across data storage, Dataflows, pipelines and Power BI semantic models.

The day starts with diagnosis, so you know where to look before changing anything. It finishes with a reusable performance checklist and an open clinic on your own scenarios.

Develop Fabric Performance Skills:

• How capacity units are consumed, smoothed and throttled, and how to protect your capacity.

• How to use the Capacity Metrics app, Monitoring hub and workspace monitoring to find the workloads driving cost.

• How to design OneLake storage, and keep Delta tables healthy with OPTIMIZE, VACUUM and V-Order.

• How to tune Dataflows Gen2, pipelines, Spark notebooks and T-SQL.

• How to choose between Import and Direct Lake, and prevent DirectQuery fallback.

• How to diagnose slow DAX using Performance Analyzer, DAX Studio and Best Practice Analyzer.

• A repeatable performance review checklist you can take back to your team.

Learn Fabric Your Way, Training Tailored to Your Needs

This Fabric Tuning & Performance training is offered in a UK-based face-to-face classroom or virtual setting and can be tailored to your needs. Struggling with a specific slow report, refresh or job? Let us know and we can focus the day on what will move your Fabric solution forwards.

Follow Our Fabric Training Learning Path

Build Your Foundations

Understanding Microsoft fabric Data Platform covers the Fabric fundamentals that this workshop builds on, if you need to strengthen your starting point first.

Learn the differences in Microsoft Fabric for data analysts with our Microsoft Fabric for Data Analysts, and prepare for building your single source of truth in Microsdoft fabric with our Medallion Architecture Deployment in Microsoft Fabric.

Get ready to administer your fabric environment with our Microsoft Fabric Administrator course.

Focused Workshops: Bring Your Data

Follow on with workshops using your own data, and apply what you have learnt to your own environment with our blended learning options.

Solve Your Performance Struggles with Expert Fabric Training

Whether BI developer, data engineer or platform owner, people who come to PTR for this training are usually dealing with the same problems:

• Why is my capacity being throttled, and which workloads are responsible?

• How do I reduce my Fabric costs without hurting the business?

• Why are my refreshes, pipelines or notebooks so slow?

• Why is my Direct Lake model falling back to DirectQuery?

• How do I find out why a report is slow to load?

If this sounds familiar, this is the course for you. We will give you a clear method for diagnosing problems and the techniques to fix them.

Delegates should have working experience of Microsoft Fabric and Power BI, such as building lakehouses, warehouses, pipelines, Dataflows or semantic models, and a basic understanding of SQL. Experience of Spark notebooks and DAX is helpful but not essential. No prior performance tuning experience is required.