Support for native queries in import and DirectQuery mode in the Power Query SDK


This content is archived and is not being updated. For the latest documentation, go to Integrate data into Microsoft Dataverse. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Users, automatically Dec 15, 2022 -

Business value

Connector developers will be able to implement native query support for their connectors in both import and DirectQuery modes using the Power Query SDK, which lets users query their data using this functionality in Power Query experiences.

Feature details

A common user ask is to have the ability to use native queries (custom SQL) in various connectors on our platform. This feature empowers custom and certified connector developers to implement native query support in their connectors, which users can then take advantage of.

See also

Native query support in Power Query custom connectors (docs)