Hi and welcome to the community !
The SonarCloud Quality Gate check is a newest addition in the Azure DevOps extensions, and is intended to be use as a Pre-Deployment Gate in Release pipelines
There is a 3rd party extension for failing the build from the Quality Gate status, it’s called SonarCloud build breaker
We are aware of the cloned Analysis Report, another user has reached us for that. Unfortunately after having done a troubleshoot session we weren’t able to find the issue on our side, so this user has opened up a case on the Microsoft developer community forum (https://developercommunity.visualstudio.com/content/problem/733768/duplicate-analysis-report-displayed-on-extensions.html)
Thank you.
Mickaël