Forum Discussion

skasper's avatar
skasper
Responsive Resident
9 years ago
Solved

DataSource.Error: SharePoint: Request failed

Hi,   I am using Power BI Desktop and trying to query data from an Excel file stored on a SharePoint Online site.    Query let Source = Excel.Workbook(Web.Contents("https://xxx.sharepoint.co...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    skasper

     

    I haven't reproduced your issue. Please delete the data source (File->Options and Settings->Data Source Settings->Clear Permission) and reconnect to see if it works.

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

skasper

 

I haven't reproduced your issue. Please delete the data source (File->Options and Settings->Data Source Settings->Clear Permission) and reconnect to see if it works.

 

Regards,

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

I also run into similar errors while refreshing the data in Power BI Desktop. In my case as well, the data is fetched from excel files stored in SharePoint Online site. I typically get the same error as stated by skasper :
DataSource.Error: SharePoint: Request failed

 

On trying the solution you mention, the data refreshment was successful and error-free.

 

However, sometimes while refreshing the dataset, I see other kinds of errors on the SharePoint Site itself indicating the unavailability of it:

On similar lines, I sometimes also encounter the following error while refreshing the dataset in Power BI Desktop:

While investigating these new errors, I read the following documentation on throttling in SharePoint:

https://docs.microsoft.com/en-us/sharepoint/dev/general-development/how-to-avoid-getting-throttled-or-blocked-in-sharepoint-online

 

How can these repititive errors be overcome? Do you recommend anything specific when it comes to using a specific Microsoft 365 license when dealing with data file retrieval from SharePoint?

 

Thanking you in advance! 🙂