While waiting for someone to respond, I tried to make a File instance from the Uri and load that. It works! Weird!
Glide.with(mContext)
.load(new File(pictureUri.getPath())) // Uri of the picture
.transform(new CircleTransform(..))
.into(profileAvatar);