Power Query Problems

How to Fix Power Query Folding Limitations with ODBC Drivers

Adam DavisAdam Davis Nov 3, 2026 869 views

Question details

Users experience query folding failures or limitations when utilizing an ODBC data source in Power Query.

How to Resolve Power Query Folding Limitations with ODBC Drivers
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 you start

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.

Solution 1Recommended

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.

1
Test Alternative ODBC Drivers

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.

2
Prioritize Foldable Operations

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.

3
Delay Non-Foldable Steps

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.

4
Check Native Query Status

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.

Optimize Query Steps and Verify Driver Capabilities
Hidden Query Folding: Do not rely entirely on the 'View Native Query' option to determine if folding is active. Monitor your database server's incoming SQL queries directly if you suspect folding is working despite the UI indicating otherwise.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download the free installation package.
  2. 2. Install the Software: Run the installer and follow the on-screen instructions to set up WPS Office on your device.
  3. 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.
Free and lightweight alternative to Microsoft Office.Highly compatible with Microsoft Excel file formats (.xlsx, .csv).Stable performance for everyday spreadsheet operations and data imports.User-friendly interface requiring zero learning curve for Excel users.
microsoft office alternative - wps office

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.