Continuous rolling storage of the updated data

[joshua1990]

Hello everybody

I have a report that is linked to our MES-System.

Here I count all Orders per Process Step as of the moment/ snapshot.

I am refreshing the data every day at 08:00 AM.

Is there any chance to save this data set or Status for the future?

I would like to determine the changes between the number of orders per process step for at least the last 3 weeks.

[v-easonf-msft]

Hi ,  @joshua1990 

As mentioned  by @Greg_Deckler  ,it is suggest to  duplicate a new query in query editor.

Then enable  the option "include  in report refresh " in All Properties.

Best Regards,
Community Support Team _ Eason

[joshua1990]

Thanks! But this means I need to create a new query every day, right?

[v-easonf-msft · Accepted solution]

Hi , @joshua1990 

Yes, it means that  you need to duplicate a new query and disable the  option "include  in report refresh " to save this query status  after each data refresh .

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Yeah, this is not an easy thing to do if I understand correctly. For each "state" that you would want to preserve, you would have to create a query, load the data, disable refresh. Then you use UNION to append your tables everything together. https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

Might be able to do something with incremental refresh but I don't see that in your case. Maybe though.

Or, dump your data into files and then use a Folder query to import them all.