If you have looked into your D365 F&O capacity, you sometimes see a lot of data being stored in the tables EventEntitySyncTables and BIIncrementalTableModifications.

I see in the code, that there are things in place to clean them up, but there be situations where this code for some reason is not executed.

The contents of the EventEntitySyncTables are basically just a table that stores CRUD changes for incremental power BI/datalake updates. It is basically just storing change type, table and recid reference

If you see that this table is exploding it would be worth to check and see if you have a batch job named Purge Incremental Changes History (Class BIIncrementalChangesHistoryPurgeJob) and if you don’t, you create it manually in the batch job screen. (I have not found a menu item for it)

It deletes records in EventEntitySyncTables that is more than 3 days old in chunks of 1.000.000 records. (See class BIIncrementalChangesHistoryPurgeJob)

About BIIncrementalTableModifications, I actually don’t see any clear code that cleans up this table. But there are some code in the class EventActionEntitySyncRefresh that cleans up. Maybe it is on the Microsoft backlog? But there are indications that a full refresh may clean things up, when you go to the entity store menu-item. (You have to do it for all)

What is very important is that Export to Data Lake is announced deprecated, and you should transition to Synapse Link. So checkout this documentation : https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/finance-data-azure-data-lake