Freezing data in current time period

[Reports]

Good afternoon,

I would like to know is there a way to freeze information from refreshing except during an indicated time period?

I am trying to get static sales, but as the staff invoice it duplicated the transaction on the system and on the table, There is however a period between 07:00 - 09:00 which these records are accurate and there are no duplicates. If I can set that table to only refresh during that time and not after it would really assist? 

[BA_Pete · Accepted solution]

Hi @Reports ,

You could put that table into a Dataflow on its own and set the refresh schedule on it to your desired timeframe, then update your desktop report to get that one table from dataflows instead of whatever the original source is.

Either that, or find a logical way to exclude the duplicates from your data as part of your Power Query tansformations.

Pete

[Reports]

Good afternoon Pete,

Thank you very much for your help, It works really well.

Regards,

John