I wanted to understand how the rows which are deleted from table are handled in incremental refresh dataset.
Does it identify the deleted rows and delete from dataset OR Do we need to do full refresh in PBI desktop and then publish?
Thanks & regards
Proud to be a Super User!
Thanks Gilbert for your reply
I have a table which contains 12 million rows. and it is modelled based on row level permissions from source system
This table is truncated and loaded on daily basis, Now I am being asked to look at the possibility to do incremental refresh for dataset which is loading this table
In case user permissions are removed from any record in source table, that data rows will not be loaded in the next etl run
I am not sure how that row will be removed from power bi dataset during the next incremental refresh if it no longer exists in source table now
Hope my question makes sense!
Handling deletes is just what I am after. Thanks for posting that link 🙂
The approach outlined by Patric is not ideal but it's the next best thing - until that capability is added to incremental refresh.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!