Do not refresh

[PowerBIIE]

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]

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]

hi @PowerBIIE ,

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

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