Need Genuine advice & Suggestions🙏. Feeling stuck in my career, while I'm trying so hard to change it

This is not a rant post at all but I'm in extreme anxiety since couple of weeks and a continous headace. And I'm expecting some good advice and suggestions

I'm working as a data analyst but due to no work satisfaction I'm trying to change my job more than 6+ months.

Initially i was getting interview calls once or twice in 2 months but suddenly since last month I'm consistently giving interviews but no luck at all(already gave 5-6 interviews in 2 months)

I'm unable to get an offer letter. And i don't know why. Sometimes getting rejected in 1st round and sometimes in 2nd but result is same, REJECTION ❌️

My questions are..

Do we need to give all technical & other answers to go for second round?

What i observed, even if i gave 9/10 answers, i got rejected.

Getting rejected based on python, sometimes it is sql, sometime it is excel as well and offcourse case studies too.

I seriously don't know how much and how hard questions i should prepare.

Are business/data analysts role becoming that tough now?

The problem with my work is, it doesn't include any technical skills. While they told me during interview but nothing like that in actual work.

Kindly help and suggest me 🙏