engine knocking and shaking

my 2001 320ci e46 shakes and has a loud knocking sound sometimes only when the eml comes on tho and it only happens in drive (its an auto) not in (N) or (P) can anyone help cos when it does this the rpm dips and occasionally stalls .. :censor: ,,,thanks