How to Fix Power Query Folding Limitations with ODBC Drivers
Question details
Users experience query folding failures or limitations when utilizing an ODBC data source in Power Query.

- Product
- Excel Power Query
- Device & OS
- not provided
- Scenario
- Optimizing data transformations by utilizing query folding over an ODBC database connection.
- Observed behavior
- Query folding unexpectedly stops working for certain steps, and the View Native Query option may appear disabled, which heavily degrades data load performance.
Before altering your query steps, verify that your ODBC driver is fully updated to the latest version provided by your database vendor, as folding relies entirely on the driver's reported capabilities.
Optimize Query Steps and Verify Driver Capabilities
Reorder your transformation steps and test different ODBC drivers to maximize query folding.
Query folding behavior in Power Query is heavily dependent on the specific ODBC driver being used. Some operations that fold seamlessly with one driver may break folding with another. Because there is no universal setting to force folding, strategically ordering your query steps is the best approach.
Download and install a different or updated ODBC driver for your specific database. Change your data source connection in Power Query to use the new driver and observe if more steps successfully fold.
In the Applied Steps pane, move highly foldable operations such as data filtering (e.g., keeping rows where a value equals 'X') and basic grouping to the very top of your transformation list.
Identify complex transformations like adding custom columns with complex logic or changing specific text casings. Move these steps to the end of your query so they do not break the folding of preceding steps.
Right-click on individual steps in the Applied Steps pane to see if 'View Native Query' is clickable. Note that with certain ODBC drivers, this option may be grayed out even if the step is actually folding in the background.

Try WPS Office for Lightweight Data Analysis
If you find yourself struggling with complex Power Query folding issues, ODBC driver limitations, or bulky software performance in Microsoft Excel, consider switching to WPS Office. It provides a highly compatible, fast, and user-friendly spreadsheet environment for handling daily data tasks efficiently.
- 1. Download WPS Office: Visit the official WPS website to download the free installation package.
- 2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your device.
- 3. Import Your Data: Open WPS Spreadsheet, navigate to the Data tab, and use the built-in import tools to seamlessly connect to your external data sources.

Frequently Asked Questions
Why is the View Native Query option grayed out when using an ODBC driver?
The View Native Query option is typically grayed out when a transformation step cannot be folded. However, when using certain ODBC drivers, Power Query may be unable to display the translated SQL syntax, causing the option to remain disabled even if query folding is successfully taking place behind the scenes.
Can I force Power Query to fold with an unsupported ODBC driver?
No. There is no universal setting or switch to force query folding. The folding process depends strictly on the ODBC driver's reported capabilities and the specific SQL functions it supports.
How can I confirm query folding is working if the Native Query option is disabled?
The most reliable method is to use a database monitoring tool (such as SQL Server Profiler or a similar utility for your database system). By monitoring the actual queries reaching the server during a Power Query refresh, you can see if the transformation logic was successfully converted into SQL.




