Forum Discussion
Incremental Refresh Power BI
Power BI is a "read only" system so it doesn't have the ability to store data beyond a refresh.
You will either have to modify the source system (you said not an option), or put in an intermediate process in place to store a previous day snapshot of data.
See if the blog will help you:
https://visualbi.com/blogs/microsoft/powerbi/historical-data-preservation-using-power-bi-dataflow/
lorenzoglima To do incremental refresh in Power BI you must have a suitable DateTime column either in your data itself (for example "Order Date") or in the source files (in case you receive daily CSV files with the data). If your column is not in DateTime then you must convert it. For example if all you have is a date then you need to pick a time (usually midnight).
for example: From "2021-08-20" to "2021-08-20T00:00:00.0"
Once you have that you can proceed to create your parameters (RangeStart and RangeEnd) and apply them as filter to your data source etc.