Is it possible to use a file that get its name changed daily, as a source file?

[JChris]

I have the following file behavior:

(Today) 28-Apr-2017: STATIC_PATH\20170428-STATIC_FILENAME
(Tomorrow) 29-Apr-2017: STATIC_PATH\20170429-STATIC_FILENAME
...
(Monday) 01-May-2017: STATIC_PATH\20170501-STATIC_FILENAME
(Tuesday) 02-May-2017: STATIC_PATH\20170502-STATIC_FILENAME
And so on...

The filename changes on a daily basis, more especifically the date part. Is there a way to use it as a source in PBI automatically, so I don't need to go into source settings everyday and update the source path by hand?

[ajinkyacgaikwad]

Please watch this video 
Here the file name keeps changing within a folder still fetchs the files
https://youtu.be/4UfkhF6uGcw

[MarcelBeug]

If you only want to get the file with todays date, you can use:

"STATIC_PATH\"&Date.ToText(DateTime.Date(DateTime.LocalNow()),"yyyyMMdd")&"-STATIC_FILENAME"

[kohlivinayak]

how to get yesterdays date.... ??

[JChris]

I want to get the file that is in the STATIC_PATH, no matter the date, the file is replaced, so yesterday file get out and todays get in the folder. Something like a regex: .*-STATIC_FILENAME would do if regex was allowed.

[v-sihou-msft]

@JChris

You can create a function to pass the file path and file name. Then you can iterator all files under that folder and combine them into one dataset. For more details, please refer to this blog: USE POWER QUERY’S GET DATA FROM FOLDER TO GET DATA FROM MULTIPLE EXCEL FILES

Regards,

[MarcelBeug]

Then you can use "Get files from folder" as suggested by @MFelix

[MFelix · Accepted solution]

Hi @JChris,

Check this video tutorial it as what you are looking for.

https://community.powerbi.com/t5/Video-Tips-and-Tricks/Combine-CSVs-and-Keep-the-File-Name/m-p/15152...

Regards

MFelix