When I was growing up, many years ago, we were sharply advised to NEVER knot embroidery.
The knot would stand out and make a small lump under the fabric, making it less than perfect!!
Weaving it in to the first few stitches almost always is enough. But it always worried me. SO easy to lose that tail!