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,

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Note that I got the same error after my SharePoint files were moved to a U.S. server (had been housed on a server in Europe). This is likely not applicable in many cases, but posted here in case your company does the same and you're spending time trying to figure out what happened. I needed to update the settings for the data source to show the new path.