Troubleshoot Excel and Power BI SharePoint Data Feed Errors
Question details
Determine why SharePoint list exports and Power BI OData connections fail on one computer but work on another.

- Product
- Microsoft Excel, Power BI, and SharePoint
- Device & OS
- not provided
- Scenario
- A user exports SharePoint lists to Excel and connects to SharePoint OData feeds in Power BI on two computers.
- Observed behavior
- The exports and connections fail on one computer but work on the other.
Have access to both computers and a SharePoint list that reproduces the error. Note which application fails and capture the complete error message before changing settings.
Update Office and test Excel add-ins
Use this approach to check whether an outdated Office installation or an Excel add-in is contributing to the export failure.
In Excel, select File > Account > Update Options > Update Now, if available. After the update finishes, retry the SharePoint list export.
On Windows, close Excel, press Windows+R, enter excel /safe, and select OK. Retry the export to see whether the error persists without add-ins loaded normally.
If the export works in Safe Mode, open Excel normally and select File > Options > Add-ins. Choose COM Add-ins in the Manage box, select Go, and disable add-ins one at a time, retrying the export after each change.

Compare affected SharePoint lists and connection details
Use this comparison to determine whether the issue affects every list or a specific export or OData connection.
Work with exported spreadsheets in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and support for Microsoft Office formats, making it easy to move existing files. It can help you work with exported spreadsheets, but it does not fix Excel or Power BI SharePoint connection errors.

Frequently Asked Questions
How do I check for Office updates in Excel?
Open Excel and select File > Account > Update Options > Update Now, if the option is available. Then retry the SharePoint export.
How can I tell whether an Excel add-in is causing the error?
On Windows, close Excel, press Windows+R, and run excel /safe. If the export works in Safe Mode, use File > Options > Add-ins to disable add-ins one at a time and retest.
Where can I check the Power BI data source settings?
In Power BI Desktop, select File > Options and settings > Data source settings. Compare the feed address and permissions with those on the working computer.
What should I record if only one SharePoint list fails?
Capture the complete error message and note the list, application, and results from other lists. Compare the same list on the working computer before requesting support.




