When I went in for a needle Biopsy the doctor injected my skin with some medicine to help numb the area where the needle biopsy was performed.
I did feel a little mild pain when the needle was inserted but after that it was not painful due to the area being numbed and it only felt like a pinch that went away within a few seconds.
There was some mild pain afterwards but even then the pain wasn't too severe and didn't last long.
I was really worried at first when going in for the needle biopsy but it wasn't that painful in my experience.