Just to double check... as I'm still hitting the 1,000,000 *cells* refresh limit.
I understand I could use filters to get under that number, but to understand the process, do you mean that I process data in Excel (PQ) outside of the data connector (i.e. on a different sheet), and then reload (delete & replace) the entire table with the new data? I am feeling a little nervous about how destructive a process that could be if something failed...
As an alternative, I'm wondering about uploading the table of emails used to delete contact records into Dataverse & creating a flow that will set a column value for matching records in the contacts table eg. flagged "delete", which I can use as the basis for a Dynamics bulk records deletion... But again, I'm unsure if Flow will be able to handle the amount of processing this will involve...
As always, I'd appreciate any input/thoughts, thx!
