CharacterMesh has to have 'Simulate Physics' enabled if you'd like to AddImpulseAtLocation

As far as I remember, my problem came from having the wrong collision or physic preset. However, I’m not 100% sure, as it dates a few month.