An external drive has to clear three hurdles: enough power to spin up, a working data connection, and a file system the machine understands.
Power is the first and most common failure. Larger drives draw more than a single port can supply, so they spin up, stall, and disconnect in a repeating cycle.
The second hurdle is the cable, where charge-only leads and damaged connectors produce a drive that lights up but never announces itself.
The third is formatting. A drive prepared on another operating system may be perfectly healthy and completely invisible, because the file system is not one this machine reads.