Forum Discussion

UbSamuel's avatar
UbSamuel
New Member
3 years ago

Losing previous data with each data refresh

Hello community,   I am using power query on excel to retrieve data from an external DB to create reports for a client. I noticed, however, that anytime I do a 'refresh all' on the power query, it ...
Need Help
UbSamuel's avatar
UbSamuel
New Member
3 years ago

Hi ams1 ,

 

Thanks for your response. 

 

What I mean by that is the timestamp. Please see the snapshot below:

 

 

On the pivot table, I set the timestamp as a filter so that the users can filter the reports for different days. As you can see in the snapshot above, the 11th of January is the earliest date. It went back much further (December, last year) but I have noticed that each day we refresh the report to get the most recent data, the oldest day is deleted.

 

I hope it is much clearer now.

 

Many thanks for your guidance.

  • ams1's avatar
    ams1
    Responsive Resident
    3 years ago

    Hi,

     

    If on every new day refresh, the oldest day is deleted, then maybe there is a limit somewhere - ex. maybe you can get only 200 days back from today.

    • UbSamuel's avatar
      UbSamuel
      New Member
      3 years ago

      Hi ams1 ,

       

      I thought the same thing and this is why I am wondering if such a limit exists and if it can be increased.