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
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.
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
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.
Source = "SharePoint.Files("https://abc001-my.sharepoint.com/personal/xxx_abc001_com")
Below is the error msgataSource.NotFound: SharePoint: Request failed (404): The remote server returned an error: (404) Not Found. (404 FILE NOT FOUND)
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:
Whenever I click any "Binary" file from the list to get to the dataset I got the the same error as you have:
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!