Reply
Frequent Visitor
Posts: 3
Registered: ‎12-13-2018
Accepted Solution

Connection to SharePoint Folder

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


Accepted Solutions
Moderator
Posts: 9,540
Registered: ‎03-10-2016

Re: Connection to SharePoint Folder

@Rammi,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Frequent Visitor
Posts: 3
Registered: ‎12-13-2018

Re: Connection to SharePoint Folder

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

View solution in original post


All Replies
Moderator
Posts: 9,540
Registered: ‎03-10-2016

Re: Connection to SharePoint Folder

@Rammi,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 3
Registered: ‎12-13-2018

Re: Connection to SharePoint Folder

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