Forum Discussion
Replacing Some data
- 1 year ago
You can achieve this with incremental refresh. Either in:
- semantic model: https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
- dataflows: https://learn.microsoft.com/en-us/power-query/dataflows/incremental-refresh
- 1 year ago
You can remove old data and load the latest records using Power Query in Power BI. You need to:
1. Load existing data
2. Filter out records from the last 3 months
3. Append new data from the CSVYou can also use Incremental Refresh to automate this process.
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
Let me know if you need further guidance
If this response was helpful, please accept it as a solution and give kudos to support other community members
- 1 year ago
Hi tonyenglish , There are several ways to achive this through Power Query as well as incrimnetal refresh please try these out
Incremental Refresh:- Set up incremental refresh in Power BI for your dataset.
- Configure it to delete and reload data for the past three months during each refresh.
Filter Old Data:
- In Power Query, filter records older than three months.
- Append the new data to existing data.
If your source is Database then you could use SQL to filter it in the source itself
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
You can achieve this with incremental refresh. Either in:
- semantic model: https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
- dataflows: https://learn.microsoft.com/en-us/power-query/dataflows/incremental-refresh