Data Import & Export

Troubleshoot Excel and Power BI SharePoint Data Feed Errors

Aamir Naveed AkramAamir Naveed Akram Nov 14, 2026 868 views

Question details

Determine why SharePoint list exports and Power BI OData connections fail on one computer but work on another.

Troubleshoot Excel and Power BI SharePoint Data Feed Errors
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.
Before you start

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.

Solution 1Recommended

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.

1
Update Office

In Excel, select File > Account > Update Options > Update Now, if available. After the update finishes, retry the SharePoint list export.

2
Start Excel in Safe Mode

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.

3
Check add-ins

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.

Update Office and test Excel add-ins
Safe Mode scope: Excel Safe Mode tests Excel add-in conflicts; it does not diagnose a Power BI OData connection by itself.
Free Microsoft Office alternative

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.

Open and edit exported spreadsheet files in WPS Spreadsheets.Compatible with Microsoft Excel XLS and XLSX formats.Use a familiar interface to ease the move from Microsoft Office.Work with a free, lightweight office suite.
QA img-9

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.