It was a while ago, but pretty sure I did back in 2009. I believe it felt some cramping when they were actually taking the biopsy sample, but other than that, it wasn't bad. Maybe some minor spotting after?
Never had one but I've seen multiple. Basically they'll insert a small tube and use suction to remove some cells from the endometrium. It can cause cramping pain and maybe spotting but you shouldn't be debilitated.