Connect to a changing path

[jafh]

Hi everyone, I need to get data from a file which name changes everyday without having to build again the connection in Power BI. For example, today the file's name is 2017-01-20.xlsx, but tomorrow it would be replaced with a new file called 2017-01-21.  Is this posible? Thank you very much for your help.

[v-cherch-msft · Accepted solution]

Hi @jafh

You may try to go to Advanced Editor to change the file path as below.

You may also go to Manage Parameters to create parameters for your file name as below. Then add the parameter to the path in Advanced Editor. Finally, you may change the file path by changing the parameters.

Regards,

Cherie