Sonarcloud API

Hi Anonymous ,

Power Query allows you to retrieve data from web services and load it into Excel. 

Please refer to the following steps to see if it helps you.

https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/

• handling authentication using the APIToken query parameter
• using Web.Contents() to do this, by passing the API token through an HTTP header

I have found a similar topic, please refer to it to see if it helps you,

https://community.powerbi.com/t5/Power-Query/Pull-data-from-a-REST-API-Authentication/td-p/246006

• use Anonymous authentication, as you already provide the authorization key.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.