Lunch and Learn: Performance Tuning Power Query And Dataflows In Power BI

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 optimizing your code, ensuring query folding takes place, increasing the resources available to the Power Query engine and using the Enhanced Compute Engine in Dataflows.

Chris Webb is a member of the Power BI Customer Advisory Team at Microsoft. He has over 20 years experience of using Microsoft BI tools, has written several books and blogs about Microsoft BI at https://blog.crossjoin.co.uk/