View native query for supported connectors

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Power Platform product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
End users, automatically - This feature is released. Sep 30, 2020

Feature details

Today in Power Query Desktop, users have the capability to view the native query emitted by certain connectors, such as the SQL connector. This capability allows users to easily see what query they're emitting as a result of operations in Power Query, and it can be used to tell when something has stopped folding.

This feature will be lighting up in Power Query Online, bringing additional self-diagnostic capabilities to users. Alongside query diagnostics, it will allow users to have a much better understanding of what is being retrieved from their data sources.