cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Hard deletes not handled in incremental refresh

Hi All,

Does anybody have any idea on how incremental refresh handles hard deletes

 

3 REPLIES 3
Highlighted
Super User IV
Super User IV

Re: Hard deletes not handled in incremental refresh

Hi there

If you have a hard delete that is after the incremental refresh window it will NOT be deleted.

For example if you refresh your data for the last 3 days, and your hard delete was from 4 days ago it will still be shown.

You would need to use the Detect Data changes to identify changes in order for them to change.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted
Regular Visitor

Re: Hard deletes not handled in incremental refresh

Thanks Gilbert for your reply,
Will it delete the record if it's in refresh window, in your example last 3 days.
Highlighted
Regular Visitor

Re: Hard deletes not handled in incremental refresh

As per my understanding, if I have configured to refresh last 6 months of data it doesn't delete record in refresh window if its deleted, it can only handle soft deletes via detect data changes

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors