Welcome to the Community.
On such cases it is recommended to use Mac OS’s built-in Disk Utility in order to test and diagnose the hard drive. There are times when the file system is corrupted or in need of repair before Finder can mount/access the storage volume. I would also recommend changing the USB cable: