Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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
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 msg:DataSource.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
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!
I have the same problem. Did anyone manage to find a solution?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.