Data source credentials required on power BI service for an API with a key

[Trotter]

Hi

I have set up a report in power BI desktop that uses an API with a key as its data source.

When I publish the report in power BI service how do I input the credentials?

It does not seem to give me an option to add a key and I have not managed to find any notes on how to do this.

Details:

In desktop I connected to the API but selecting:

• Get data
• From Web
• Advanced
• Addted the URL for API at the top
• Under HTTP request header parameters I input: "Ocp-Apim-Subscription-Key" in the first box followed by the key in the 2nd box.

When I publish and go to the data source credentials I cannot see any option that lets me input the key.

How can I input the credentials required so that the report will refresh?

Thanks

Regards

Trotter

[ibarrau · Accepted solution]

Hi. Reading your comment it looks like the credentials are written at the code in the header of the request. That means you are not using powerbi credentials (auth2, basic, windows, etc). When editing the credentials look for "Anonymous" category. Power Bi Service will asume that it doesn't need credentials for running the request because it's a public request or they already are in the power query code.

I hope that helps,

[Trotter]

Thanks @ibarrau 

I've tested on one of the APIs and that worked!!