Forum Discussion
Question about Incremental Refresh
- No, that is not how incremental refresh works. Incremental refresh updates records that have changed. It is not an append, it just overwrites records that have changed since the last update. This prevents having to load the entire dataset every time. That is the purpose and function of incremental refresh.
There is no "easy" way to do what you are trying to do. You would basically have to create a new query for every refresh. You would use that query once, mark it to not refresh and then copy and paste it, use that one once, mark it to not refresh, and so on. Then you could create a single master Append query and remove duplicates most likely. As I said, no easy way that I know of...
Hi Anonymous ,
For incremental refresh, datasets are filtered by using Power Query date/time parameters with the reserved, case-sensitive names RangeStart and RangeEnd. These parameters are used to filter the data imported into Power BI Desktop, and also to dynamically partition the data into ranges once published to the Power BI service. The parameter values are substituted by the service to filter for each partition. There's no need to set them in dataset settings in the service. Once published, the parameter values are overridden automatically by the Power BI service.
For more information about how incremental works, the following attached links could also help you to understand:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.