Biopsy pain or lack thereof has been discussed here many times over the years. I think the general consensus is that it was uncomfortable but not painful. However, there are a few like Tall Allen who described it as very painful.
Personally, I had IV sedation so there was nothing but sweet dreams.
Jim