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 t...
Need Help
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).

    • Akshay123's avatar
      Akshay123
      Helper I
      2 years ago

      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.