HSG Test

Hello guys! I am 11 days late on my period when it shows, in my 9th rounds on clomid and my doctor said that I should take higher dose from 50mg to 100mg. And then next week he can make a HSG procedure for me if I want to. Just to check my fallopean tube and everything. I just want to ask is anyone done this test and did you conceive? Or is it painful? Thanks in advance for your responds.