Blue yeti not showing up

I just recently bumped into this issue. Ive had my blue yeti since 2022 Christmas without a problem. These past months i havent had my blue yeti connected to my pc as i didnt need it and was busy. Yesterday i wanted to use it, but when i plugged it in it didnt show up as connected. The red light was on but it wasnt registering in “sound” settings. Not as input or output device. I went online and looked for help but they told me to try a different usb port, reset my pc, make sure all cables were connected, update my drivers and none worked. I then tried it on a whole separate pc and it didnt show up either.

What do i need to do?? Do i need to buy a new cable? Please give your advice