Always a positive symbol. No matter what the rest of the dream implies, if the dream ends with a rainbow, particularly if you find the pot of gold, the dream is a portent of the end of all your troubles followed by much happiness.