I had a biopsy about three years ago. The prep is negligible. Generally the patient is given a light sedative. I can't remember feeling any pain. If there was some, it was not memorable.
It got boring laying on my stomach for a fair amount of time.
Afterwards I had a great lunch with my friend.
Based on my experience there is no need to fret. Others may have had different experiences, though.