I had this test about
a year ago, I think its called an MRI Enterography.
I was running to the bathroom before I even got into the MRI machine! Then for hours after. I threw up almost all the solution though so I think for me most of it never even made it to my colon. I also have a shot before the MRI to slow down my digestive tract and another shot during the MRI to do the same thing. Not sure if you had that with yours, but I'm sure that's what made me throw up so much.
I also had a CT scan to look at my pancreas but for that only had to drink 1 bottle of that barium not 4 bottles like for the MRI. Much easier!