Connection to SharePoint Folder

[Anonymous]

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

[v-yuezhe-msft · Accepted 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

[melvferrer-iwg]

Hi,

I'm experiencing this.  Is there an issue with sharepoint connection?

Thanks for the help.

[v-yuezhe-msft · Accepted 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

[Anonymous · Accepted solution]

Solved, the issue was i was using the sharepoint link rather than the URL.

[NAOS]

Hi, I have the exact same issues but even using the site url doesnt solve the problem. Any suggestions?

[Anonymous]

Same
Access Fobidden
Did you solve it?