Hi,
I have pulled data into Power Query using a URL data source directing to an excel file in Sharepoint.
I can transform and refresh fine in the Power Query Editor, but when I go to Load, it stops at only a few thousand rows in and gets stuck.
The Load ultimately fails and gives the below message window.
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error]
Any ideas on how to fix?
Hi @UKFan12 ,
What you need to do is in power bi desktop go to query editor then right click your web data source and click Advanced Editor. This will give you access to M code behind it. You need to specify timeout interval in there manually. See below image and then should work hopefully.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @UKFan12 ,
What you need to do is in power bi desktop go to query editor then right click your web data source and click Advanced Editor. This will give you access to M code behind it. You need to specify timeout interval in there manually. See below image and then should work hopefully.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
