Forum Discussion
Using the SharePoint Folder connector
Any update on this?
As others have pointed out filtering the folder/directory path isn't really viable as everything in the entire site is loaded in order to filter.
We've done a fair bit of business logic planning around this kind of folder specific loading.
If the comnnector can only pull in every doc from a site/doc library then why call it "Sharepoint Folder" - the connector should be called "Sharepoint Site" and the limitation made clear.
Cheers
This is copied from: http://www.microsofttrends.com/2015/07/29/connecting-to-sharepoint-online-document-libraries-from-power-bi/
If you want to connect to your document libraries (for example if you wanted to report on the number of documents being uploaded) you can do this through the OData feed instead.
The URL for the OData feed is: https://yoursharepointsite/_vti_bin/listdata.svc to bring up all the lists and document libraries in Power BI Desktop or if you want to connect to a specific list the URL will be: https://yoursharepointsite/_vti_bin/listdata.svc/ListName.
Once you have created a connection to your list or document library, you can use the table of items as a data source and create dashboards and reports based on this data.
----------------------------------
We had a similar issue at our company, this was the only way I found that works. Basically abandon the Sharepoint Folder type and use OData instead. Hope this helps!
-Fellow Frustrated User