Advisor suggests to change my research topic after unsuccessful start, unsure what to do
You should be talking to your advisor(s) and you may have some good points to discuss.

If you think you have some relevant ideas, then you should discuss them with your advisor - one may be the "key" you are looking for.

If, after considering your points, the advisor still has good reason to think that there is no future, then you should accept that decision, clear in the knowledge that you put your points across.

So, discuss with your advisor and make an informed choice with them.