joists when I installed a fan elsewhere. Given the beam is about a foot
thick, I don't have any bits that could do the job either.

Use a paddle bit with an extension.
Take your time, don't overload the drill, frequently ease up on it and
let the internal fan cool the motor. Done with care, even a cheap
drill will have no problem.