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

[saj]

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

[v-danhe-msft]

Hi @saj,

Based on my test, it could work on my side. Could you please check the verification method of your credential?

I suggest you use the "OAuth2" and enter your organizational account.

Regards,

Daniel He

[saj]

Hi Daniel / @v-danhe-msft

Happy New Year.

I don't recognise the screenshot as something from the Desktop client. I am trying to connect to an on-premise sharepoint folder. I am using PBI Desktop optimised for report server.

Thanks