- Version
- Download
- File Size 0.00 KB
- File Count 0
- Create Date 20 May 2022
- Last Updated 20 May 2022
Sydney Power BI User Group May 2022
Hello Sydney Power BI User Group Members
In this meetup, we had the pleasure of welcoming back Chris Webb from the Microsoft CAT team. Chris talked on the topic of Performance Tuning Power Query and Dataflows in Power BI
Topic: Performance Tuning Power Query and Dataflows in Power BI
Speaker: Chris Webb
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.
Speaker Bio:
Chris Webb is Principal Program Manager at Microsoft and a member of the Power BI Customer Advisory Team. He is based in the UK, and has 20+ years of using Microsoft BI tools. Check out his blog at https://blog.crossjoin.co.uk/
