Greetings,
I think teknology9 is correct. Backwards compatibility is not guaranteed. The drives "keying" and x4 transfer is supported by the boards socket but that's about it.
The 970 is PCie 3, where as the board was designed when only 2.0 was available. It also uses a more modern controller and communication architecture.
Seeing it in Linux means nothing, and if the board doesn't see the drive natively installing windows to it by whatever means is also not going to help.
Things you might try:
Clearing the CMOS and retesting. If you don't have a correct setting, controller operate mode, etc, it might keep the drive from being correctly detected. If you are running a 4th gen devils canyon processor, I would not upgrade to F8.
Do contact support and see what they say, you might get lucky. 4th gen CPU's do not always do well with 5th gen Broadwell capable BIOS'. Stick with F6 unless told to upgrade by support.