Do you roll with failures or do you load and try for your "expected" outcome?

I had to find a hidden gnome that could supply me with gunpowder, but she was so much on edge that she lit up the barrel of gunpowder and blew up the whole room, leaving half of my party dead. A suicide gnome bomber. I couldn't convince her that I was not an enemy. Reloaded just to see if I could successfully do it, but much preferred the first outcome of the dice roll, so had to reload and try 6 times until I failed again. What a game!