Fix Slow REST API Data Retrieval in Excel 2021
Question details
The user is experiencing noticeably slower REST API data retrieval speeds in Excel 2021 compared to earlier versions of the software and needs to identify and resolve the cause.

- Product
- Microsoft Excel 2021
- Device & OS
- not provided
- Scenario
- Pulling data from a REST API endpoint using Power Query in Excel 2021 for data analysis.
- Observed behavior
- API data retrieval and query execution times take significantly longer in Excel 2021 than they did in older Excel versions, indicating potential integration or networking overhead.
Ensure you have a stable internet connection and verify that the target REST API endpoint server is not currently experiencing high latency or downtime before modifying any Excel settings.
Gather Diagnostics and Consult Microsoft Specialists
Because this issue often stems from deep integration changes between Excel 2021's Power Query engine and REST APIs, escalating to the Microsoft Q&A Community with proper diagnostics is the most effective approach.
Excel 2021 introduced updates to the Power Query engine, security protocols, and data privacy firewalls. These backend changes can sometimes cause API calls to evaluate slower than in Excel 2016 or 2019.
To get an accurate fix, Microsoft engineers will need specific details about how your workbook interacts with the API.
Note your exact request method (GET/POST), the authentication type (OAuth, API Key, Basic), and the specific REST API endpoint URL.
Document the exact query execution times in Excel 2021 versus the earlier versions to provide a clear performance benchmark.
Open the Power Query Editor, go to the 'Home' tab, click 'Advanced Editor', and copy your complete M code script.
Navigate to the Microsoft Q&A Community website and create a new detailed thread under the Excel or Power Query tags using the information gathered.

Optimize Power Query Performance Settings
Clearing the data cache and enabling Fast Data Load can occasionally bypass localized bottlenecks and improve retrieval speeds.
Switch to WPS Office for a Lightweight, Efficient Experience
If complex integrations and sluggish performance in heavy spreadsheet software are slowing down your daily workflow, consider trying WPS Office. It provides robust spreadsheet capabilities, seamless performance, and a lightweight footprint that runs smoothly on almost any hardware.
- 1. Visit the website: Go to the official WPS Office website to access the latest version.
- 2. Download the software: Click the 'Free Download' button to get the lightweight installer for your operating system.
- 3. Install and launch: Run the downloaded file to install, then open WPS Spreadsheets to manage your data without performance lag.

Frequently Asked Questions
Why is Power Query slower in Excel 2021 than in Excel 2016 or 2019?
Excel 2021 includes updated security, stricter privacy settings, and a newer Power Query engine. It may handle API authentication and firewall rules more strictly, sometimes resulting in processing overhead compared to older, less restrictive versions.
Does clearing the Power Query cache really improve REST API speeds?
Yes, if your cache is bloated or corrupted, Excel might struggle to evaluate query steps efficiently. Clearing the cache forces Excel to fetch fresh data directly from the REST API, which can resolve localized performance drops.
How can I view the exact execution time of my REST API query?
You can use the 'Query Diagnostics' feature inside the Power Query Editor. Go to the 'Tools' tab, click 'Start Diagnostics', refresh your preview, and then click 'Stop Diagnostics' to generate a detailed time record of your API calls.




