Forum Discussion
Connect directly to a specific SharePoint Folder - not the entire site
Most Valuable ProfessionalYou can avoid it by this way
1. Create a blank query in Power BI.
2. Paste the below code there
let
Source = SharePoint.Contents("https://mycompany-my.sharepoint.com/xyzabc/", [ApiVersion = 15])
in
Source
3. Replace https://mycompany-my.sharepoint.com/xyzabc/ with your company's sharepoint root URL. (You already know this as you are able to connect it using Sharepoint.Folders.
4. Now, first column will have many tables. Click the table which contains your folder (this should be at the bottom). You may be required to click that column mulitple times depending upon how much down your folder is.
5. Once you reach to the required folder, do the required transformations
Sorry your soluion is actually what I am trying to avoid doing. The probelm I have by doing it this way, is you first load the entrie site and then filter to a folder. When you refresh you refresh the query for the entire site, in my case that is millions of rows. I only want to hit and refresh the specific folder to avoid that large data refresh.