Is it possible to use a file that get its name changed daily, as a source file?
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?
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.