I had a biopsy 12mths ago following a scan that showed thickened womb lining and had a Mirena fitted at the same time,
My experience was a positive one, I was advised to take two paracetamol and two ibuprofen ahead of the procedure and then had aneasthesic gel followed by local anaesthetic to my cervix (actually, that might not be correct, it was somewhere internally!). The procedure was a little uncomfortable, similar to having a smear, with one or two 'pinches' but overall it wasn't as bad as I feared. The medical team in the room - think it was three nurses and the gynae- were superb, chatting to me the whole time to keep my mind off what was happening. I'll also add that I suffer from VA and Lichen Sclerosus, both under control but both adding to discomfort in the vaginal/vulval area. If I had to have another biopsy in the future I'd go local aneasthesic again.
I know we are all different when it comes to levels of pain and what we're happy with but, if you've had smears, injections and loop diathermy in the past without a problem, I'd say you'd be OK with a biopsy. But, as others have said, you could always discuss your concerns and options with the clinical team before the day.
Good luck, hope it goes as well for you as it did for me.
Suzie