'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel for the Web Cannot Refresh Power Query Data
Question details
Users are unable to refresh Power Query data connections when working directly in Excel for the web, despite the refresh working correctly in the desktop application.
- Product
- Excel for the Web
- Device & OS
- not provided
- Scenario
- Attempting to update external data sources and Power Query connections directly within the browser interface.
- Observed behavior
- The data refresh action fails or is greyed out, often caused by the presence of external CSV sources or unsupported web connections.
Verify that your internet connection is stable and ensure your workbook is saved in a supported cloud location like OneDrive or SharePoint before attempting to refresh external data.
Check Data Source Cloud Accessibility
Excel for the web can only refresh data if the sources are stored online and supported by the web environment. Moving local files to the cloud can resolve this issue.
Many Power Query refresh failures in the web version happen because the query relies on a local file path (like a C: drive CSV) that the web server cannot access.
Open your workbook in the Excel Desktop app, go to the Data tab, select 'Get Data', and click 'Data Source Settings' to review where your query is pulling data from.
If you see local file paths (like local CSVs), upload those source files to SharePoint or OneDrive.
In Power Query Editor, change the source step to point to the new cloud URL instead of the local directory, then save and publish back to Excel for the web.
Use Excel Desktop to Refresh Data
If your data source is inherently unsupported for web refresh, use the desktop version of Excel as a reliable workaround to update your queries.
Provide a Sanitized Sample File for Troubleshooting
If the issue persists and you need community or support assistance, creating a sanitized sample file helps others diagnose complex query problems safely.
Try WPS Office for Seamless Spreadsheet Management
If you are frustrated by web-based connection limitations in Microsoft Excel, consider switching to WPS Office. As a free, lightweight desktop alternative, it offers robust spreadsheet tools, familiar interfaces, and avoids the complicated cloud-refresh restrictions of browser-based editors.
- 1. Download the installer: Visit the official WPS Office website and download the free version for your operating system.
- 2. Install WPS Office: Run the installation file and follow the quick setup wizard to install the suite.
- 3. Open your spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx or .csv files to manage your data seamlessly.
Frequently Asked Questions
Why does my Power Query refresh work on the desktop app but fail in the browser?
The browser version of Excel operates in a sandboxed cloud environment. It cannot reach into your local hard drive or corporate network to fetch data from local CSVs or on-premises databases, which the desktop application can easily access.
Which data sources are officially supported for refresh in Excel for the web?
Excel for the web generally supports refreshing data from cloud-accessible services like SharePoint online, OneDrive, OData feeds, and certain Azure databases. Local files and legacy database connections are usually blocked.
How can I share a sample file for support without exposing company data?
You should create a copy of your file and manually replace confidential text with generic words (like 'Client A') and scramble financial numbers. Ensure that the Power Query steps remain structurally identical so the technical error can still be reproduced.
