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.
Hi ,
I encountered problem while trying to get data from a excel file in onedrive for which I have permission to view and edit.
Whereas the owner who uploaded the file was able to connect to power BI Desktop Using the same steps below, and was also able to connect the excel file to PowerBI template file with no error.
StepS Followed:
1.Get Data ->Web
URL:
https://*******my.sharepoint.com/personal/**********_onmicrosoft_com/Documents/Document/Uni/Master%20Excel.xlsx
Error:
Unable To Connect
We encountered an error while trying to connect
Details: "SharePoint: Request failed: https://********my.sharepoint.com/personal/**********_onmicrosoft_com/Documents/Document/Uni/Master Excel_xlsx/_api/contextinfo"
Any Help Appreciated,Kindly suggest your thoughts on this.
Many Thanks,
V
I am facing same issue. Have you been able to resolve this?
Does this excel file stored on Onedrive for business or SharePoint site? From your URL and error message, it seems that you get data from sharepoint site. Please ensure that you have corresponding permission to this excel file. Please refer to the link below to see the details.
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
Regards,
Charlie Liao
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.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |