cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
panshu77 Frequent Visitor
Frequent Visitor

failed to connect power bi desktop to onedrive sharepoint folder

I was trying to connect power bi desktop to get data from one of my own onedrive sharepoint folders.

 

I went to "get data", selected "sharepoint folder" and then input the url

"https://abc001-my.sharepoint.com/personal/xxx_abc_com/"

 

signned in with my business microsoft account, and then tried to connect.

 

The connection failed with the following error message:

Details: "Web.Contents failed to get contents from 'https://abc001-my.sharepoint.com/personal/xxx_abc_com/_api/web/lists/getbyid('fedaa18d-8384-436c-aaa...' (500): Internal Server Error"

 

Please help. thanks.

 

 

 

 

3 REPLIES 3
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: failed to connect power bi desktop to onedrive sharepoint folder

@panshu77,

Do you connect to OneDrive for business folder? If so, what is your Power BI Desktop version?

I can connect to OneDrive for business folder in latest version of Power BI Desktop(2.65.5313.1381). Could you please paste the following code in Advanced Editor of a blank query and check if there are issues?

let
    Source = SharePoint.Files("https://abc001-my.sharepoint.com/personal/xxx_abc001_com")
in
    Source



Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
panshu77 Frequent Visitor
Frequent Visitor

Re: failed to connect power bi desktop to onedrive sharepoint folder

Thanks for the help. My version is 2.65.5313.621 64-bit (December 2018).

 

I opened a blank query and tried the code you suggested.

 

= let
    Source = "SharePoint.Files("https://abc001-my.sharepoint.com/personal/xxx_abc001_com")
in
    Source

 

Below is the error msgSmiley Very HappyataSource.NotFound: SharePoint: Request failed (404): The remote server returned an error: (404) Not Found. (404 FILE NOT FOUND)
Details:
    DataSourceKind=SharePoint
    DataSourcePath=https://abc001-my.sharepoint.com/personal/xxx_abc001_com
    SPRequestGuid=c641bb9e-401c-7000-d643-4ddb1235011a
    Url=https://slb001-my.sharepoint.com/personal/xxx_abc001_com/_vti_bin/ListData.svc

 

Gordon2 Member
Member

Re: failed to connect power bi desktop to onedrive sharepoint folder

I am struggling with the same issue right now. Did you finally solve this?

 

When I am connecting to the sharepoint folder with the query like the one suggested here:

 

= let
    Source = "SharePoint.Files("https://abc001-my.sharepoint.com/personal/xxx_abc001_com")
in
    Source

(so I have to get rid of API=15 to get the list the files in the folder)

I found there is an error in the list:

 

Capture.PNG

Whenever I click any "Binary" file from the list to get to the dataset I got the the same error as you have:

 

Capture1.PNG

 

I am using the latest PBI Desktop version: 2.66.5376.2521 64-bit (February 2019)

The trick is that I cannot remove this error anyway. Even "remove errors" option doesn't work.

 

MVPs please help!