Good point Graham!
Julian,
I always try to avoid unplugging the power cable at the microUSB end to minimise the possibility of damaging the socket (which is definitely a weak point on the earlier version Raspberry Pi's). I have in the past 'improved' the grip on several loose sockets for myself and other users by gently squeezing the socket back into shape with small pliers, but that requires disassembling the PilotAware and very careful adjustment, and doesn't always work. I have described the process several times on here before - see this previous thread here as an example if you want to give it a try....
http://forum.pilotaware.com/index.php/topic,1885.msg20358.html#msg20358If the connection
can be 'stabilised' as above, it would then be worth securing the connector in place by the careful addition of either a blob of silicone or hot glue applied very carefully around the connector to hold it in position. I still have a PAW Classic that was repaired this way several years ago, which still runs with its original power cable!
Alternative options -
If you know what you are doing, you could power the unit via the Bridge as suggested by Sean, or you could replace the Raspberry Pi if you can find a replacement (they are still rarer than hen's teeth with the worldwide chip shortage though), or you could try contacting Jeremy Curtis (of Charge4 fame) who has fitted replacement microUSB sockets for several PAW users (including myself) in the past (you can PM him from his JCurtis posts in the thread linked above).
Please let us know how you get on.
Best Regards
Peter