It depends on the type of biopsy you're having.
If it's a surgery biopsy then you'll be asleep and sedated during the surgery biopsy procedure but if you get a needle biopsy you will fee a slight small sharp pinch feeling at the site of the biopsy but it won't last long.