Do not refresh

PowerBIIE · ‎02-25-2023

Hi,

How do I set up the PowerBI dataset not to refresh data before today's date?

I want to keep the historical data but add today's data only and do this on a daily basis. So I have an accurate report where the data doesn't change.

Thank you

N

artemus · ‎02-26-2023

Sounds like you need to do incremental refresh:

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

Note: This requires a paid subscription.

adudani · ‎02-25-2023

hi @PowerBIIE ,

I think custom partitions would solve this assuming it's in direct query.

reference: (19) Demystifying Custom Partitions in Power BI - YouTube

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,
Avinash