Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Automated updates of the source

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

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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