Hi @james_prakash ,
Welcome to SonarSource community! 
Please check these 2 community guides and review them to see if this matches your problem:
- [Coverage] Troubleshooting guide for .NET code coverage import
- [Coverage & Test Data] Generate Reports for C#, VB.net
If those do not help you, please take a look at my example pipeline yaml file for Azure DevOps that imports VSTests and coverage correctly:
It’s for SonarCloud, but it’s similar for SonarQube.
If all that fails, please add sonar.verbose=true to the extraProperties key in SonarQubePrepare task with Azure pipelines yaml and share the logs here.
Joe