Unable to refresh one or more data connections

[Syndicate_Admin]

I have 2 files on SharePoint (- see attached file).

The first holds the data and the second is using power query to connect to the file's tables.

This is how the connection is made to SharePoint:

Source = SharePoint.Files("https://My_Company.sharepoint.com/sites/Aero-RD-Department", [ApiVersion = 15])

When making refresh locally from excel file, the refresh is successful, but when trying to refresh from online, I get an error message - see attached file.

Why?

How can I solve it?

[Syndicate_Admin]

Thank you for the elaborated answer.

This is a site which I created so I have access and permissions however manual refresh option is not available.

I will explore your suggestions and update.

[v-yanjiang-msft]

Hi @Syndicate_Admin ,

To troubleshoot the issue, firstly please check if you have the necessary permissions to access the SharePoint site. Then Ensure that the SharePoint site is accessible from the online environment where you're trying to refresh the data. Check if there are any issues with the data source itself, such as missing or corrupted files. Try refreshing the data connections manually to see if that resolves the issue. If all these don't help, please try the below suggestion:

• One reason for this error could be that you are using Excel Online, which does not support all data refresh scenarios. According to this article, external users of a tenant cannot refresh data connections from Excel Online. You may need to open the file from the Excel desktop app and refresh the data source from there.
• Another reason for this error could be that your data connection is pointing to another Excel file that is stored in a document library. In this case, you may need to install the x64 OLEDB driver on your SharePoint server, as explained in this answer. This driver can help SharePoint access the data from the Excel file.
• A third reason for this error could be that your data connection is using Power Query, which has some limitations and requirements for refreshing data in Excel Online. According to this article, you may need to enable the Power Query Data Gateway service and configure the credentials for your data sources.

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.