My 2TB MyBook Essential external hard drive won't show

I have been following with WD support for past two months for a similar problem I am facing, where the power supply cord is not working and the product is under warranty. They have kept me running from one commitment to other for the past two months and NOTHING. There has not been any more frustrating product purchase I have made ever. WD is extremely UNPROFESSIONAL and has absolutely no methodology to deal with the customers who have paid for their INCOMPETENT product.