User Profile
apaceAW
Regular Visitor
Joined 1 year ago
User Widgets
Contributions
Power BI Incremental Refresh Behavior Question
Hello. I'm trying to understand the behavior of Power BI's incremental refresh functionality. I'm not a Power BI developer but I have a decent understanding of the basics. Here's the setup in the report: Large table of 100 million rows Parameters for range start and range end applied to the last_updated_date in the table Incremental refresh set up as below - Detect data changes turned on for the same last_updated_date column Note: I just checked this dataset again and the Detect data changes has been unchecked but my question below still stands Here's the scenario I'm trying to figure out. Let's say we've done the full initial load and it has pulled in all the available data. Yesterday, a record with an original last_updated_date of 1/1/2024 was updated to 4/7/2025 which now falls within my refresh window. Since the original record has a date that is not with my last 7 days, is Power BI going to duplicate this record? My understanding is that Power BI deletes whatever is in the defined date range and pulls in fresh data. Therefore, I should assume my row will be duplicated? Based on what I have found online I think yes, but I've been unable to test my theory.
