Saving Historical Data Daily

[erhan_79]

Hi Dear Community ;

i need your supports about below issue , let me explain what i need and my scenario 

i have Table A from en excel file and i download every day new one of that table to power bi.I need to save my new excel file on to previous excel file per day.for below sample  ; on 20.06.2020 i uploaded to power bi left report (brown marked)  .And on 21.06.2020 i saved on my previous excel and i refreshed my datas with new excel file at on the middle one report below ( yellow marked) 

i just would like to save somewhere my previous data per each day and when i upload new excel and refresh the report also new data will be saved under previous data per each day .How can it be possible and could you help me about this issue pls .

thanks in advance 

[rubinboer]

hi there

power bi is great but what you asking for if i read correctly is not what power bi was purposed for. You will have to do something else before the data get to power bi or copy every file to power bi (im lazy so i wont go this route :)).

1. you can maintain the excel file by copying the new data to previous excel file and use that file as the source  for power bi

2. create a document library in SharePoint online or onedrive. upload your new file to the document library and have flow copy the data from the uploaded file to a file you will use as the source for power bi. the same flow can be used to delete the uploaded file form the document library when the copy is done.

regards

[parry2k · Accepted solution]

@erhan_79 you shouldn't overwrite daily excel file rather add a new file for every day and then combine excel file in Power BI so that you have a big dataset from excel file for all the dates.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡