Forum Discussion
PowerBIIE
3 years agoFrequent Visitor
Do not refresh
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
2 Replies
- adudaniMemorable Member
hi PowerBIIE ,
I think custom partitions would solve this assuming it's in direct query.
reference: (19) Demystifying Custom Partitions in Power BI - YouTube
- artemusMicrosoft Employee
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.