Connect to CSV File in Power Query with Variable Name

[telhearne1]

Hi All,

Please Login or Register  to view this content.

I Have created a connection to a CSV file using the above code.

The issue I have is that a new source file is created daily and is named YYYYMMDDTESTFILE.

Can someone please tell me how I amend the code so that when I run the query, the source file name updates dynamically to todays date?

Many Thanks in advance

[alansidman]

In that case, I would build a parameter query where you can indicate the name of the file and it will input it into the Source step. Are you familiar with how to build parameters? If not, then this link should help you build one for your needs. Of course you will need to adapt the concept to your particular situation

https://www.youtube.com/watch?v=gK2yBpiITvI