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])
I open PBI Desktop
Get Data ---> Sharepoint List ---> it asks for URL -----> and then credentials and then it stopped going forward.
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.
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.
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
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.
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!
Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications