Forum

Power Query from On...
 
Notifications
Clear all

Power Query from One Drive for Business- too many files

2 Posts
2 Users
0 Reactions
34 Views
(@carolina-vidrascu)
Posts: 4
Active Member
Topic starter
 

Hi, our company is an international company with one drive hosted for the whole group. I managed to find the bath that will connect to the one drive just for our company from the group, but they are far too many files. Is it possible to point it to a specific folder on the web drive via web, so it can be updated by anyone that has access to the folder? Essentially for it to work like PQ from a folder, but to use a web connection.

Thank you

Carolina


 
Posted : 02/06/2026 10:18 pm
Riny van Eekelen
(@riny)
Posts: 1441
Member Moderator
 

@carolina-vidrascu

Difficult to answer without more details on how you connect to the folder. You could try the SharePoint.Contens function rather than SharePoint.Files.

It will let you navigate to the correct SP folder and not read through all files on the entire SP site to get to your folder on a refresh.

 


 
Posted : 03/06/2026 2:48 pm
Share:
0