Forum Discussion

skasper's avatar
skasper
Icon for Responsive Resident rankResponsive 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
Icon for Microsoft Employee rankMicrosoft 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,

khalidwaleed's avatar
khalidwaleed
Frequent Visitor
4 years ago

I had the same problem. This solution also worked for me.