cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
skasper Member
Member

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.com/sites/management/Freigegebene%20Dokumente/salaries.xlsx"), null, true),
    tbl_salaries_Table = Source{[Item="tbl_salaries",Kind="Table"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(tbl_salaries_Table,{{"Name", type text}, {"Net Salary", type number}, {"Total Cost", type number}, {"Hours/Day", Int64.Type}, {"Latest Adjustment", type date}, {"Adjustment Value", Int64.Type}, {"Net Bonus", Int64.Type}, {"Total Bonus Cost", Int64.Type}, {"Bonus Type", type text}})
in
    #"Changed Type"

Error

DataSource.Error: SharePoint: Request failed: https://xxx.sharepoint.com/sites/management/Freigegebene Dokumente/salaries_xlsx/_api/contextinfo
Details:
    DataSourceKind=SharePoint
    DataSourcePath=https://xxx.sharepoint.com/sites/management/Freigegebene%20Dokumente/salaries_xlsx/_api/contextinfo
    SPRequestGuid=ef84049e-601e-4000-ef17-0555bf13666b

 

 

Any idea, what I am doing wrong here?

Thank you.

Best - Sascha
Please always mark accepted solutions. It helps others with similar questions or problems. Thank you.
1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: DataSource.Error: SharePoint: Request failed

@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,

3 REPLIES 3
Moderator v-sihou-msft
Moderator

Re: DataSource.Error: SharePoint: Request failed

@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,

Highlighted
mugdhadesai Visitor
Visitor

Re: DataSource.Error: SharePoint: Request failed

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

skasper Member
Member

Re: DataSource.Error: SharePoint: Request failed

Hi @v-sihou-msft,

 

thank you. I did that and it works now. I also updated to the July version, so I am not sure, what really was the fix.

Best - Sascha
Please always mark accepted solutions. It helps others with similar questions or problems. Thank you.