September 10, 2021
Hello, i'd like to automate a process that power query solves me. If possible, i'd like to automatically import files to power query, transform them and them export them automatically to a folder. All this without combining the files.
So basically, i want to automate the ingest, the transformation and the export of files from a folder.
Thank you in advance and sorry for my not so good english (not a native speaker)
July 16, 2010
Power Query cannot load files to a folder. It can only load data to Power Pivot/Data Model, table in a worksheet, PivotTable, Pivot Chart or as connection only.
At best, you could create a query in a new file and close & load the data to a table which you save in said folder. You can then reference the data in these files as you wish. You would need to create a separate file containing a single query for each file you require as your end result.