Diagnosing Queries
The Power Query M engine is an extremely powerful and fast data transformation and data preparation engine used across an array of products, including:
- Excel for Windows
- Excel for Mac
- Power BI
- Power Apps
- Power Automate
- ADF
- SSIS
- SQL Server Analysis Services
- Dynamics 365 Customer Insights
While both fast and powerful, there are times when you may find that a particular query is not as performant as desired. In these instances, Query Diagnostics can help you pinpoint problematic expressions and better understand what Power Query is doing in order to identify areas for query optimization. This recipe demonstrates how a user can use Query Diagnostics to troubleshoot a query and identify how the query might be optimized to be more performant.
Getting ready
To get ready, import the FactCurrencyRate table from the AdventureWorksDW2022 database by doing the following:
- Open Power BI Desktop...
