cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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

Hi, there is a previous post that outlines it clearly....

 

I found some other way to conenct to Sharepoint Folder .
First connect using Sharepoint List connector --> edit --> click on the Source at Applied Step --> Replace the Query with this 
= SharePoint.Contents("www.yourishareSite.com", [ApiVersion = 14])

Highlighted
Helper I
Helper I

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

HOw would I do this. I am not sure , where to go and what to do.

PLease advise in steps.

Thank you.

Highlighted
Helper I
Helper I

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

I open PBI Desktop

Get Data ---> Sharepoint List ---> it asks for URL -----> and then credentials and then it stopped going forward.

Highlighted
Helper II
Helper II

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

This topic is about Sharepoint Folders and not Sharepoint Lists.

When you enter the url are you taking note of the info icon "Enter the root url for the site and not including sub folders"?

 

Are you displaying the Formula bar in Power Query?

In terms of Sharepoint Files create a blank query data source then manually enter the source details in the formula bar eg 

=SharePoint.Contents("www.yourishareSite.com", [ApiVersion = 14])

 

If you are similar to us you cannot create a data source to Sharepoint files using the UI but you have to manually create the first step. From then on you have a normal dataset.

Highlighted
Helper I
Helper I

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

Yes, I have noticed to enter the Root URL , not the list i.e. http://portal2.mea.ey.net/

Also I have tried doing this using a blank query, 

=SharePoint.Contents("http://portal2.mea.ey.net", [ApiVersion = 14]), the result is the same. 

 

Please advise, if there is a solution for this issue. PBI desktop is unable to access Sharepoint 2013 On Prem.

 

Thanks

Highlighted
Helper II
Helper II

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

Hi, sorry can't help any more. We've got it working with our on prem SharePoint 2013.

 

Good luck.

Highlighted
Helper I
Helper I

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

Thanks for your assistance. !

Highlighted
Frequent Visitor

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

HI,

 

Just wanted to check if you were able to find a solution for this, even I am struggling to conenct power bi to on-permises sharepoint file

Highlighted
Helper II
Helper II

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

Hi, yes @Harish12137 

 

We are currently Sharepoint 2013 and by default Power BI assumes a higher level so you cannot directly connect to a file using the UI. That said it is easy to sort out.

 

Make sure you can see the 'Formula Bar'

I connect to a SP List then edit the first step.

eg initial step

=SharePoint.Tables("http://sp.site.com/MySite", [ApiVersion = 15])

 

Change Tables to Files and reduce the ApiVersion to 14. 

= SharePoint.Files("http://sp.site.com/MySite", [ApiVersion = 14])

 

There you go, good luck.

Highlighted
Frequent Visitor

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

Hi @saj ,

 

Thankyou so much for a quick response, yes changing to sharepoint.files worked!!

 

Regards,

Harish

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors