Power Query Problems

Fix Snowflake ODBC Connection Errors in Excel Power Query

Adam DavisAdam Davis Nov 13, 2026 868 views

Question details

The user needs to resolve Snowflake ODBC connection crashes and access violation errors in Excel Power Query so that Snowflake queries load consistently.

Fix Snowflake ODBC Connection Errors in Excel Power Query
Product
Microsoft Excel Power Query and Snowflake ODBC driver
Device & OS
not provided
Scenario
A user is querying Snowflake from Excel Power Query through an ODBC connection; similar queries may work differently or trigger crashes.
Observed behavior
Power Query fails with an access violation such as error code 0xC0000005, or the connection crashes when running the query.
Before you start

Before changing drivers, close all Excel and Power Query windows, note the current Snowflake ODBC driver version and bitness, and make sure you have administrator rights to install or update the ODBC driver.

Solution 1Recommended

Update the Snowflake ODBC Driver and Recreate the Power Query Connection

Use this first when Power Query crashes or returns error 0xC0000005; an outdated or mismatched Snowflake ODBC driver is the most common cause.

Excel Power Query calls the Snowflake ODBC driver directly, so a driver that is older than the connector version, or a 32-bit/64-bit mismatch, can lead to access violations like 0xC0000005.

1
Check the current Snowflake ODBC driver version

Open the Windows ODBC Data Source Administrator, select the Snowflake DSN, and note the driver version and platform shown on the Drivers tab.

2
Download the latest compatible Snowflake ODBC driver

Go to the Snowflake developer downloads page at https://www.snowflake.com/en/developers/downloads/odbc/ and download the driver that matches your Excel bitness.

3
Install and register the updated driver

Run the installer with administrator rights, then reopen the ODBC Data Source Administrator to confirm the new driver version is listed.

4
Recreate or refresh the Power Query connection

In Excel, open Power Query Editor, delete the existing Snowflake connection or data source, and create a new connection using the updated DSN or Snowflake connector.

5
Test the native SQL query and WHERE clause

Run a basic SELECT statement first, then add the WHERE clause from the failing query to verify that the query returns data without triggering the access violation.

Update the Snowflake ODBC Driver and Recreate the Power Query Connection
Expected result: The Snowflake query should load in Power Query without the 0xC0000005 access violation.
Free Microsoft Office alternative

Use WPS Office to Work with Snowflake Exports Without Excel Power Query Crashes

When Excel Power Query and the Snowflake ODBC driver continue to fail, WPS Office gives you a free, lightweight environment for opening, analyzing, and sharing the exported data with familiar spreadsheet tools and .xlsx compatibility.

Free spreadsheet, writer, and presentation tools with no subscription requiredOpens and saves .xlsx, .xls, and .csv files so exported Snowflake reports remain compatibleFamiliar ribbon-style interface makes migration from Microsoft Excel simpleLightweight performance reduces the complexity of daily data tasksData import tools in WPS Spreadsheets help you continue working with external data sources
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel Power Query crash with Snowflake ODBC error 0xC0000005?

This access violation usually indicates an outdated Snowflake ODBC driver, a mismatch between 32-bit or 64-bit Excel and the driver, or an unsupported native SQL clause. Update the driver, match the bitness, and test the SQL query.

How do I know whether to install the 32-bit or 64-bit Snowflake ODBC driver?

Check Excel via File > Account > About Excel. Install the Snowflake ODBC driver that matches your Excel installation: 64-bit Excel requires the 64-bit driver, and 32-bit Excel requires the 32-bit driver.

Where can I download the latest Snowflake ODBC driver?

Download it from the official Snowflake developer downloads page at https://www.snowflake.com/en/developers/downloads/odbc/. After installing, verify the version in the ODBC Data Source Administrator.

Do I have to recreate my Power Query after updating the Snowflake ODBC driver?

It is recommended to recreate or refresh the connection so Excel Power Query picks up the new driver. Then test a basic SELECT statement before re-adding the original WHERE clause.

Can WPS Office use Snowflake data if Excel Power Query keeps crashing?

WPS Spreadsheets can open .xlsx, .xls, and .csv exports and has data import tools. It is not a Power Query replacement, but you can use it to continue reviewing and sharing Snowflake-exported data.