Forum Discussion
Repetitive transformations on individual files in a sharepoint folder in power query
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 ?
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])
2 Replies
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])Load all the folders and group the tables based on their path
