Repetitive transformations on individual files in a sharepoint folder in power query

[shubhampatil]

Hello everyone, 

I am working on a project where I am calculating a ratio for each employee. I have a target quota file and i have another folder where weekly pipeline come in. I want to calculate this ratio for each weekly pipeline and when a new weekly pipeline is generated i want all the transformations to be applied on the new weekly pipeline file. I have these files in 2 different sharepoint folder. I have connected the Target quota file which is going to be constant but how do i connect the weekly pipeline directory folder where new files are going to be added every week and i do not want to combine the files. Please if anyone can help me with it ?

[Omid_Motamedise]

Load all the folders and group the tables based on their path

[KNP · Accepted solution]

If you create a new staging query connecting to this folder, you can then reference the query in your other queries.

Create a blank query and then add this code into the formula bar.

Replace YOURDOMAIN and YOURSITE with appropriate values.

= SharePoint.Files("https://YOURDOMAIN.sharepoint.com/sites/YOURSITE", [ApiVersion = 15])