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....
You don't need to manually copy paste this, just have PQ point to a folder
You can place the file on Sharepoint and setup Incremental refresh.
You can try Enhanced compute Engine in the dataflow which will dump the data in a managed SQL instance so your queries will fold and will be fast