Forum Discussion

jafh's avatar
jafh
Frequent Visitor
8 years ago
Solved

Connect to a changing path

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's avatar
    v-cherch-msft
    8 years ago

    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

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    8 years ago

    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