Reply
saj Regular Visitor
Regular Visitor
Posts: 22
Registered: ‎03-27-2017

Power BI on premise - connect to on premise Sharepoint folder - Access to the resource is forbidden.

Hi, I am trying to get at a folder on our on premise Sharepoint site. 

 

I've tried a "Sharepoint Folder" eg http://site.ourdomain.com/subsite/ but the desktop will not allow access and errors with "Access to the resource is forbidden."

 

I can get the PBI desktop to connect to the UNC path eg \\site.ourdomain.com\subsite\shared documents\administration

and all is good in PBI desktop. The issue occurs when I try to set up a refresh schedule on our on premise Power BI site.

The error I get when trying to set up the credentials is

"We got the IO error '53' while trying to access the path '\\site.ourdomain.com\subsite\shared documents\administration'."

 

I've tried correct case and even including %20 instead of the spaces but I've not managed to get eithe rapproach working as needed.

 

Any help gratefully received.

Thanks

Moderator
Posts: 9,489
Registered: ‎03-10-2016

Re: Power BI on premise - connect to on premise Sharepoint folder - Access to the resource is forbid

[ Edited ]

@saj,

I am unable to reproduce your issue on my side.

When I connect to SharePoint folder in Power BI Desktop optimized for report server, everything works well. Do you use Windows credential? If you are using SharePoint Online, please use Microsoft account to connect to the data source in power BI Desktop optimized for report server.

Capture.PNG1.PNG

In addition, regarding to the error message about UNC path, please check if the file is occupied by other programs and you have appropriate permission on it.


Regards,
Lydia

saj Regular Visitor
Regular Visitor
Posts: 22
Registered: ‎03-27-2017

Re: Power BI on premise - connect to on premise Sharepoint folder - Access to the resource is forbid

Hi Lydia / @v-yuezhe-msft

Happy New Year.

 

Yes I use Windows credentials, we've even tried using our Farm Admin account as it has no permission restrictions (to our knowledge). We are running SP2013.

 

In terms of UNC then I can connect to it in Desktop (optimised for Report Server) no problem. The issue occurs when I try to set up a refresh schedule on the report server. So by the fact I can connect from Desktop this confirms I have the approriate permissions and PBI Desktop is happy with the state of the files.

 

Thanks

saj Regular Visitor
Regular Visitor
Posts: 22
Registered: ‎03-27-2017

Re: Power BI on premise - connect to on premise Sharepoint folder - Access to the resource is forbid

Hi @v-yuezhe-msft

We've done some more digging. We have a development box and I am able to connect onto a Sharepoint Folder.

 

Our live infrastructure has load balancers and mirrored servers so what do we need to do to access folders on our LIVE Sharepoint infrastructure?

 

Thanks

 

 

 

 

Moderator
Posts: 9,489
Registered: ‎03-10-2016

Re: Power BI on premise - connect to on premise Sharepoint folder - Access to the resource is forbid

@saj,

In terms of UNC path, I suspect the issue is caused by the live infrastructure. What is the result if you configure load balancers and mirrored servers for development box?

Regards,
Lydia

Highlighted
saj Regular Visitor
Regular Visitor
Posts: 22
Registered: ‎03-27-2017

Re: Power BI on premise - connect to on premise Sharepoint folder - Access to the resource is forbid

Hi @v-yuezhe-msft I do not have the resource to configure our development environment as a test. Can you advise or point me in the direction to confirm Power BI supports on premise Sharepoint folders in a standard load balanced / mirrored infrastructure? Thanks