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 have had my organisation creat a public group sharepoint site, for me to upload excel files on to in the following folder structure:
->Monthly Reports
-> Capex
->Excela1.xlsx
->Excela2.xlsx
->Excela3.xlsx
->Excela4.xlsx
-> Opex
->Excelb1.xlsx
->Excelb2.xlsx
->Excelb3.xlsx
->Excelb4.xlsx
I am trying to connect to the Monthly Reports top folder, so as to pull all the excel workbooks, however am getting the following error when attempting this:
____________________________________________
Unable to connect
We encountered an error while trying to connect.
Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (500 INTERNAL SERVER ERROR)
OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (500 INTERNAL SERVER ERROR)
OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (500 INTERNAL SERVER ERROR)"
____________________________________________
OR
____________________________________________
Unable to connect
We encountered an error while trying to connect.
Details: "Access to the resource is forbidden."
____________________________________________
I am the owner of this site, so not entierly sure where im going wrong with this?
Regards Rammi
Solved! Go to Solution.
@Anonymous,
What URL do you put in SharePoint Folder connector of Power BI Desktop?
Please make sure that you are entering the site URL of your SharePoint site in Power BI Desktop, if you are using SharePoint online, please use Microsoft account authentication, if you are using on-premises sharepoint, please use Windows authentication.
Regards,
Lydia
Hi,
I'm experiencing this. Is there an issue with sharepoint connection?
Thanks for the help.
@Anonymous,
What URL do you put in SharePoint Folder connector of Power BI Desktop?
Please make sure that you are entering the site URL of your SharePoint site in Power BI Desktop, if you are using SharePoint online, please use Microsoft account authentication, if you are using on-premises sharepoint, please use Windows authentication.
Regards,
Lydia
Hi, I have the exact same issues but even using the site url doesnt solve the problem. Any suggestions?
Same
Access Fobidden
Did you solve it?
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.