Forum Discussion
Question about Incremental Refresh
Here is our scenario: We have data in our CRM system. Things like sales opportunities, amount, probability of closing the deal, etc. Normally, these records are overwritten in the CRM s...
- 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...
I doubt that looking at the document. https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
You can explore the advance options at https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
parry2k , Greg_Deckler , Can you please help on this