When role is deleted on EntraID, during the next sync cycle the DNN Local role associated with that role will be deleted. If that role has been used to give permissions to a specific workspace or report through the persona bar (storing the permissions in the PBI_ObjectPermissions table), the synchronization fails to delete the roles because the foreign key between PBI_ObjectPermissions and Roles is not set as DELETE CASCADE.