Forum Discussion

Reports's avatar
Reports
New Member
3 years ago
Solved

Freezing data in current time period

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 d...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    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

BA_Pete's avatar
BA_Pete
Super User
3 years ago

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's avatar
Reports
New Member
3 years ago

Good afternoon Pete,

 

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

 

Regards,

John