Forum Discussion

Akshay123's avatar
Akshay123
Helper I
2 years ago

Maintain Historic Data

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.

Need Help

4 Replies

  • audreygerred's avatar
    audreygerred
    Super User
    2 years ago

    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's avatar
      Akshay123
      Helper I
      2 years ago

      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's avatar
        audreygerred
        Super User
        2 years ago

        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).