Forum Discussion
Solved
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 calculat...
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])
Omid_Motamedise
Super User
Super UserLoad all the folders and group the tables based on their path