Maintain Historic Data

[Akshay123]

Hi Experts,

I have two excel files, one is with current week data and other Historical data.

Every Friday I used to update current week file data and will copy the last week data and update it to Historical data.

Is there any way that Hostorical data file get updates automatically when new data arrives in other file.

[audreygerred]

Hi! You could have a folder in Sharepoint and just have the files landed there, then in Power BI use the Sharepoint folder connecter. This way you don't have to move the files around or worry about running out of rows in the hostorical Excel file as it grows. I would save them as csv though. Once you are in Power BI and use the SharePoint folder connector the files will get appeneded and each time a new file is added and you refresh your semantic model the new file will get brought in.

[Akshay123]

Hi @audreygerred 
Thanks for your response!
Requirement is to show current week data in one page and Historic data in 2nd page in Power BI

[audreygerred]

Hi! You could achieve that by setting relative date filters on the 'filters on this page' section of the filter pane (assuming your files have some sort of date field).

[Akshay123]

Every week I need to do that manually in desktop level. Once the current week file data updated & symentic model refreshes all the changes should happen.