Power Query Problems

Troubleshoot Slow Excel Power Query Refreshes from Access

Steve KSteve K Nov 13, 2026 868 views

Question details

The user needs to identify why Excel Power Query takes more than five minutes to refresh data from an Access database.

Troubleshoot Slow Excel Power Query Refreshes from Access
Product
Microsoft Excel Power Query and Microsoft Access
Device & OS
not provided
Scenario
Refreshing an Excel Power Query connection that imports data from an Access database.
Observed behavior
The refresh takes more than five minutes. The source database, query complexity, Office configuration, or database damage may be contributing to the delay.
Before you start

Identify the Access file used by the slow query and record its refresh time. Have a small Access table and, if available, a second database ready so you can compare refresh behavior.

Solution 1Recommended

Compare a simple Access table with the slow query

Start here to determine whether the delay affects one query, one database, or multiple Access connections.

1
Create a small test table

In Access, open the affected database and select Create > Table. Add a few rows of simple data and save the table with a recognizable test name.

2
Import the test table into Excel

Open a blank Excel workbook and select Data > Get Data > From Database > From Microsoft Access Database. Choose the affected database, select the test table in Navigator, and click Load.

3
Measure a refresh

In Excel, open Data > Queries & Connections, right-click the test query, and select Refresh. Record how long it takes and compare that time with the original query.

4
Compare another database

Repeat the import and refresh with a small table in a different Access database. If only the original query is slow, open it through Data > Queries & Connections > Edit and review its Applied Steps, especially merges, grouping, and custom calculations.

Compare a simple Access table with the slow query
Use the comparison to choose the next step: A fast simple-table refresh points toward the original query or its source objects. Delays across tables in one database suggest a database-specific issue; delays across multiple databases suggest a broader Office or connection issue. These comparisons narrow the investigation but do not prove a single cause.
Free Microsoft Office alternative

Use WPS Spreadsheet to work with exported Access data

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel files, making migration straightforward for everyday spreadsheet work. Export Access results to an Excel file and open them in WPS Spreadsheet for review and analysis. WPS does not repair Microsoft Office or replace the Excel Power Query Access refresh workflow.

Open and edit Microsoft Excel .xlsx and .xls files.Review Access data exported to Excel without relying on a live Power Query refresh.Use familiar spreadsheet tools for sorting, filtering, and calculations.Move everyday spreadsheet work to a free, lightweight Office alternative.
microsoft office alternative - wps office

Frequently Asked Questions

Does a refresh taking more than five minutes mean my Access database is damaged?

No. Query complexity, data volume, connection conditions, and Office configuration can also cause delays. Import a small table through Excel's Data > Get Data > From Database > From Microsoft Access Database and compare its refresh time before assuming database damage.

What should I check if the simple table refreshes quickly?

Open the original query through Data > Queries & Connections, right-click it, and select Edit. Review Applied Steps for expensive operations such as merges, grouping, and custom calculations, and compare the amount of data with the small test table.

What if every Access database refreshes slowly?

Update Office through File > Account > Update Options > Update Now, restart the computer, and test again. If the problem persists on Windows, consider Office Online Repair and provide support with your Office build and comparison results.

Can I compact an Access database while other people are using it?

Compact and Repair requires exclusive access. Ask other users to close the database, close Excel connections to it, and make a copy of the file before selecting Database Tools > Compact and Repair Database in Access.

Can WPS Office fix my Excel Power Query refresh?

No. WPS Office does not repair Excel's Power Query engine or its Access connection. For work that does not require live refreshes, export the Access results to an Excel file and use WPS Spreadsheet's Open command to review and edit that data.