Power Query / Get & Transform - new exports > new connections

Hi!

I am wondering... Let's say you have to create a report every month. The source data exists of multiple files. They are all pretty different. So you decide to use Power Query and bring them all together in one file, so at least you have some sort of db; everything together in one file.

You think, hey this is easier because you create the connection with the source and the data is loaded onto the db file / sheet.

But then what about next month? You'll have a new file, a new export. If you have to create the connection all over again, what is the use of using PQ? How do you use PQ to only create a connection once? And have the rest loaded by default?

Hopefully I am being clear....

Hopefully you get my question Thanks!

if filenames are the same (the same structure etc but different data) but different folder - change source path only then refresh if it will be not refreshed automatically.

excel doesn't read wishful thinking (yet! )

Originally Posted by sandy666

if filenames are the same (the same structure etc but different data) but different folder - change source path only then refresh if it will be not refreshed automatically.

excel doesn't read wishful thinking (yet! )

But what's the best practice if file names are not the same?

So you've a lot of work