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,

mugdhadesai's avatar
mugdhadesai
Regular Visitor
9 years ago

Hi,

 

I was doing the same and was getting exactly the same error.

But just now I updated Power BI Desktop to the latest July version, and it is working fine now.

Get Data > Sharepoint folder used to work before, but no longer works now.

So now I use Get Data > Web > give path of the excel file (with only name of sharepoint site > folder > subfolder > file name.xlsx)

No other symbols/code.

 

Thanks

Mugdha