How to Fix Power Query Malformed Web Response Error in Excel
Question details
Users are unable to refresh their data connections due to a malformed web response error linked to cloud storage.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Refreshing Power Query files connected to SharePoint, OneDrive, or Microsoft Teams.
- Observed behavior
- Power Query fails to update and displays a malformed web response error message. This issue affects multiple workbooks and might be tied to specific cached credentials or network setups.
Verify that your internet connection is stable and that you can successfully access the target SharePoint or OneDrive folders via your web browser.
Clear Global Permissions and Re-authenticate
Clearing cached data source credentials forces Power Query to request a fresh login, resolving authentication conflicts.
Open your workbook, navigate to the Data tab on the Excel ribbon, and click on 'Get Data' followed by 'Data Source Settings'.
Select 'Global permissions' at the top of the window. Find the URL for your SharePoint or OneDrive, click on it, and select 'Clear Permissions' from the dropdown.
Close the settings window and click 'Refresh All' on the Data tab. When prompted to authenticate, choose 'Organizational account' and enter your current credentials.
Isolate Network or Account Issues
Determine if the error is specific to your local network, a temporary server outage, or an individual user profile.
Try WPS Office for Seamless and Lightweight Data Management
If you are tired of complex connection errors and heavy software, WPS Office provides a lightweight, highly compatible alternative to Microsoft Office. It handles your daily spreadsheet tasks smoothly without the resource drain.
Frequently Asked Questions
Why does Power Query show a malformed web response error?
This error typically indicates that Excel received an unexpected response format from the server. It is most commonly caused by expired or corrupted login credentials cached in Excel's Data Source Settings, or by temporary network interruptions.
Will clearing my Data Source Settings delete my queries?
No. Clearing permissions only removes the saved usernames and passwords used to connect to your data sources. Your actual queries, transformation steps, and workbook data models remain completely intact.
What if the error continues after I sign in again?
If clearing permissions does not work, the issue might be related to your network configuration. Check if a VPN or firewall is blocking the connection, ensure your Office application is updated, or consult your IT administrator with a screenshot of the error.
