Forum Discussion
adam_mac
5 years agoHelper I
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 fi...
- 5 years ago
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
5 years agoNot applicable
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 !!