Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.