On approximately December 9th 2019 Microsoft stealth-released a new feature in version 9.1.0.5 of the Dynamics 365 configuration migration tool to filter exported records. This has undoubtedly been one of the most desired features for this tool by those who have used it to prepare complex data sets.
I suspect this tool has historically been named the “configuration” migration tool to emphasize the limited intended use of this tool to be used for “configuration” data and not complex data migration purposes. Those who ignored this limitation would live with the fact that all records for the selected entities would be exported, and then post-process the exported data to remove unwanted records.
Now that the filtering feature is here, it should streamline data export efforts. I’ve done some some early exploring to see how it works and what it can do and here is what I found.