Dynamic Data Source file name

[RD_PowerBI24]

Hi, 

I have a daily data source file that requires accessing, however each the name of the source file itself is different with a new datetime stamp appended at the end:

For example each the file has the following name followed by the YYYY-MM-DD-HH-MM-SS:

DELIVERY ADDRESS & TYPE PP32024-02-04-14-25-00

DELIVERY ADDRESS & TYPE PP32024-02-05-14-25-08

DELIVERY ADDRESS & TYPE PP32024-02-06-14-25-07

Is there a way of using a "contains" to reference the first part of the source file so that it is dynamic for all future files?

If so, how do I write this code?

Thanks!

[amitchandak]

@RD_PowerBI24 Load the files as a folder, and there before expand of binary data you can filter data using contains

[RD_PowerBI24]

Thanks Amit. However, this didn't seem to work for the text.contains function or I was doing it wrong.. As it is a cumulative file of records I found another solution which works and allows the new file to replace the previous day's one without explicit reference.