Switching to Data Analyst

Hi. I am currently working as an SQL Engineer - Support with almost 2 years of experience and 6 months of internship experience as Business Analyst (Stakeholder Management). I want to switch to Data Analyst profile as that was the field that I wanted to pursue my career in but due to the COVID pandemic, I accepted this profile. I have done MCA from a Mumbai University affiliated college in 2022 and have an understanding of the general Data Analyst stack (SQL, Excel, Tableau, Power BI, Alteryx, Python). I have also completed various personal projects for my portfolio on the technologies mentioned above. I have been applying for various Analyst/BI/Data Analyst related jobs since last year's October but haven't heard back from anyone. I want to understand what I am doing wrong or how should I change my approach regarding the job switch. Any suggestions/guidance is welcomed.