Forum Discussion
Slow query - multiple appended queries
Hi I have a power query (excel) that reads and cleans data from text files. Theew is a separate text file for each month and I append the new month's query to the original query each month....
Where does the process control system save the generated files to?
You could use Power Auomate to detect when a new file with a specific name was generated and have it automatically copy the file into your query source folder.
Pete
The files are saved to an on premises server.
Ok, is that some form of Blob Storage? If so, you could potentially query the file structure with PQ, filter to only files that have a name like the ones you want, and replicate the Folder Connector behaviour by creating your transformations in a function.
It sounds complicated, but it's not really.
Pete