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....
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