Data source settings - Load file using wildcard match

[adam_mac]

hi, a pretty common problem im sure but i havent been able to find a solution. I load a file into my dashboard every week from the same folder (deleting and replacing the previous weeks file). The file name is "ExampleFile_05022021.xlsx". The last part (the date part) obviously changes every week meaning i have to update it in my data source settings every week. 

Is there a way for me to use a wildcard that looka for the partial name of the file e.g. *ExampleFile_*? This would be more dynamic than my current setup. 

Any advise appreciated. 

[mahoneypat · Accepted solution]

At least two ways to solve this one

1. Use a Power Automate flow to move the file (from email?) to the final location (SharePoint/OneDrive?) renaming it as part of that

2. Use the SharePoint or Folder connectors so you see all the filenames, then filter on the filename column for Contains "ExampleFile".

Pat

[Anonymous]

@adam_mac  you can make use of query parameters https://sqlskull.com/2020/10/23/change-the-data-source-dynamically-in-power-bi-using-parameters/ 

Appreciate you kudos , Press the thums up button !!