If it spins up then it's receiving power. Now the power and data cables are of course separate so all that tells us is that if the data cable is connected, it should work. This means one of a few things: either the motherboard port you're using isn't configured correctly, the cable itself is bad, or the drive is bad.
With that board, there are 6 white SATA ports and it looks like they're all part of one controller. So if your other drives work then the port should be configured correctly. There are two modes, I believe, AHCI and RAID. It's possible if you have it set to RAID that there's another BIOS that's part of the RAID controller and you need to enter that and configure the drive there (initialize it), but if you're on AHCI it should show up in the main BIOS.
If that looks good then all you can do is try to swap a known good SATA cable. It sounds like your DVD drive works, so when you moved the connector from the DVD drive to the WD Black it should've tested this. If all you did was swap the connector on the mainboard and didn't swap the connector on the drive then you should try this instead because it sounds like all the ports work and you'd want to test the cable.
If neither cable works, and the port doesn't matter and the drive spins then the drive is defective. WD has a good RMA program and "Drive not recognized" or "Drive incompatible" is absolutely a thing that happens. I happen to have eight WD Blacks and I've used the RMA program before.