Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hopefully this is the right board. I've tried scouring the web and haven't found anything. It seems everything out there is about combining files and similar data sets.
Background:
I am trying to automate a refresh process for a Power BI dashboard. The data needs to be updated on a schedule. The data files are contained within a directory of hundreds of other files. The specific data I need will be automatically downloaded into this directory. The needed file will have the same name every download EXCEPT for the last 6 digits signifying the version of the file.
Problem:
Each time my process updates I need to grab the correct file based on name bearing in mind that the file name will be the same except for the last 6 digits of the file name. I also need to grab the most current version of the file, which I should be able to do based on create date. I don’t need to combine anything, I just need the correct file every month.
Any help is appreciated.
Solved! Go to Solution.
"Each time my process updates I need to grab the correct file based on name bearing in mind that the file name will be the same except for the last 6 digits of the file name. I also need to grab the most current version of the file, which I should be able to do based on create date." Is there a conflict between these 2 requirements?
--
There are ways to customise and automate file loads from the same directory, for example, most recent file or most recent file with an identifiable pattern in the name.
If you can define a repeatable algorithm, then there will be a way to automate it.
For example
or
"Each time my process updates I need to grab the correct file based on name bearing in mind that the file name will be the same except for the last 6 digits of the file name. I also need to grab the most current version of the file, which I should be able to do based on create date." Is there a conflict between these 2 requirements?
--
There are ways to customise and automate file loads from the same directory, for example, most recent file or most recent file with an identifiable pattern in the name.
If you can define a repeatable algorithm, then there will be a way to automate it.
For example
or
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
13 | |
8 | |
8 | |
7 |
User | Count |
---|---|
17 | |
11 | |
7 | |
6 | |
6 |