SQLBits 2022

Performance Tuning Power Query And Dataflows In Power BI

Performance tune Power Query in Power BI and Power BI Dataflows

Whether you are transforming data in the Power Query Editor in Power BI Desktop or using Power BI Dataflows it's important that your Power Query queries run as quickly as possible. In this session you'll learn how to diagnose Power Query performance problems using features like SQL Profiler, Query Diagnostics and Query Plans, and then fix them by optimising your code, ensuring query folding takes place, increasing the resources available to the Power Query engine and using the Enhanced Compute Engine in Dataflows.

Feedback Link - https://sqlb.it/?7324

Speaker

Chris Webb is a member of the Power BI Customer Advisory Team at Microsoft.

Chris Webb's Sessions

What's new in Power Query in Power BI, Fabric and Excel?

Connect Excel to Power BI data with Live Connected Tables

Fabric Power Hour

Fabric Direct Lake Deep Dive

Query folding in Power Query

Performance Tuning Power Query And Dataflows In Power BI

Creating Tables In Power Query And M Using #table()

Power BI: Business Intelligence Strategy, Vision, & Roadmap

Performance tuning Power BI dataset refresh

Advanced analytics features in Power BI

Top tips for the accidental Power BI administrator

Introduction To Dataflows In Power BI

Using Analysis Services MD as a Data Source for Power BI

Introduction to Azure Analysis Services

Building A Reporting Solution Using Power Query

Power Query: Beyond The Basics

DAXMD: SSAS Multidimensional meets DAX and Power View

Advanced Security with Analysis Services Multidimensional

Fun with Scoped Assignments in MDX

Implementing Common Business Calculations in DAX

Common Analysis Services design mistakes and how to avoid them