Forum Discussion
Folder Query Editor - Which Query Runs First?
So I have a dataset that connects to a folder and brings in multiple Excel files. When doing this, Power BI asks you to setup a sample file to transform. Then there is the main query that you intiall...
v-lili6-msft
Community Support
Community Supporthi, Anonymous
You could refer this blog:
https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder
"Power BI run through all the files in the folder performing the transformation steps you listed in the sample transformation file? Then once all the files are loaded it runs through the main query transformations
Best Regards,
Lin