This saved my life. I turned on resizeBAR in bios then suddenly nothing worked even after I turn it back off. Create a ton of issues and this undetectable sata was the last one which bugged me for a really long time.
Exact same issue, the drive shows up in bios and windows but for god sake cant be detected by ubuntu. Trying to find solutions everywhere but no luck. This exact solution solved the issue.