Excel file name Chaging in Power Query

[FAMH]

Spoiler

Hello Community , 

  I am loading an excel file to Power BI  ,sotred in Azure Blob Storage, . This  excel file is changing name every Hour .When I refresh data, I get the error the file name does not excist because the previous was deleted and a new one excist . Is there a solution or an effecient approach knowing , I do not have the option to get the excel file name not changing  

Best Regards 

[ppm1]

If there is just a single file in that folder, you can use the {0} syntax to get the first record/file (instead of directly referencing the file name). In your query, get to the step that shows the files, hit the fx button near the formula bar and then add {0} to the previous step reference.

Pat

[FAMH]

Thank for taking time to answer and your help . There is multiple files in the forlder . 

Best Regards