While direct moonlight is ideal, the energy of the moon still reaches through clouds. You can still make moon water during a cloudy night, but try to find a spot with the least obstruction to maximize its energy.