'Alm_InvalidRequest_PurgeRequired' - Dataset xxx changes will cause data deletion

Hi dmkblesser ,

Thanks for sharing the follow-up. Running Process Clear in SSMS only wipes the table data, but it doesn’t actually signal to Fabric that it can drop/recreate the dataset. That’s why you still hit the same Alm_InvalidRequest_PurgeRequired error the deployment engine is blocking the metadata change itself, not just the data. Right now the only supported ways to allow this purge are either through the Fabric CLI with the --allow-purge flag, or via a pipeline configured to permit purge. Since you mentioned you can’t adjust the pipeline and CLI isn’t an option, the best next step is to raise a support ticket with Microsoft so they can confirm if this is the expected behavior or a bug (especially since 12 of your models went through successfully and 1 did not).
I’d recommend raising a support ticket with Microsoft so it’s officially logged and can help influence future improvements. You can do that here.
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

Regards,
Akhil.