Reporting API error - Expression Error: The Authorization header is only supported when connecting anonymously

Problem

While trying to connect to the Process Manager Reporting API through Excel or Power BI, the user experiences the error called Expression Error: The Authorization header is only supported when connecting anonymously

Solution

This is an issue on the Excel and/or Power BI side. Microsoft has provided a fix for this through the below article:

• The 'Authorization' header is only supported when connecting anonymously from sonar cloud API