Automated updates of the source

[ALEKSGOD]

Hello,

I would like to improve the way source for my power Bi report in updated. 

The main source is excel file. Every month new excel file is added to the folder. Excel file is updated monthly (to the old data are added data for the last month) 

path looks sth like this - \\Year\fiscal month\excel file
In the last folder there is more files (.txt & xlsx & csv). 

When new excel file is available I have to change manually in the source in power bi name of the month folder (eg. from P03 to P04) and the name of the excel file (eg. from 'Revenue23 HU P03' to 'Revenue23 HU P04') any idea how could I automate this changes?
Thanks,
Aleks

[watkinnc · Accepted solution]

If you are using a folder as the data source (which you should be), you can just filter by Date Created, Is Latest (or maybe it's just Latest). You could also just sort by Date Created descending and just keep the first  row.

--Nate