SESSION Details

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 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

Starts: 11:20 12th Mar 2022
Ends: 12:10 12th Mar 2022

Q&As

Short Description
- Performance tune Power Query in Power BI and Power BI Dataflows

Slidedeck Link

Performance tuning Power Query and dataflows.pptx

Speakers

Chris Webb

Tags

AzureIntelligence and AnalyticsNoCode Data EngineerOptimisingExcelPower BIAdvancedHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference

Previous
Next

Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.