Forum Discussion
Data source settings - Load file using wildcard match
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.
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
2 Replies
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 !!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
