Redgum, not sure if this will be useful to you but I did a draw test today and think I have found the problem. With all the fuses on, the car was draining around 0.75-1.0amps. This is after removing fuse 26 to stop the light inside boot from being lit and doors closed. When fuse 50 was removed, reading dropped to 0.25-0.35 amps.
Based on the Z4 fuse diagram from another webpage, fuse 50 is for Radio Amplifier and it seems right as audio player is not working without the fuse. To add, audio player stopped working immediately after a battery replacement in 2021 and turning on randomly a couple of times on its own for few minutes. Current battery drain problem started after the audio player turned on and continued to work since this April. So, based on this and draw test, I think audio player is to be blamed here. I will continue to monitor the battery voltage for few more days and if it stays good, I need to move on to fixing the audio player.