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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Fabric Community Update - January 2025
Find out what's new and trending in the Fabric community.
