There is no compelling evidence that MRI contrast agent causes cancer. Gadolinium (the stuff that’s in the contrast agent) can deposit in the body, e.g. in the brain, but if this even has any consequences is still unclear. Nonetheless there is some nice research going on how to drastically reduce the amount of contrast agent needs to be administered through image postprocessing.