Enter credentials for Web API when publishing to Power BI Service

[jasonyeung87]

Hi,

I created a report on Power BI desktop which grabs data from an API. I use the "Web" data source and enter the Web API key as the credentials. It connects to the API and I'm able to generate various visualizations.

I publish this report to Power BI Service and want to schedule a data refresh every day. I need to enter my credentials, but it's not giving me an option to enter a Web API key.

It only gives me the Anonymous, Basic and OAuth2 authentication methods. I tried Basic and a user's account, but it doesn't work. I was wondering how do I set theauthentication method to Web API Key in Power BI Service?

[nitishsh91 · Accepted solution]

Hi @jasonyeung87 

Please go through below link, I believe it should help you in sorting out this problem:

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

[jasonyeung87]

Hi,

I tried using basic authentication, but adding the API key (instead of the user name). I was able to make the connection. I think it is the nature of the REST API that I was using. I thought it needed to be the Web API authentication method. I'll mark your solution as accepted.

[EdwngJs]

Hello, Could you please show step-by-step how you did? 

Thanks

[jasonyeung87]

Hi,

thanks for the link. I tried the suggestions in the link by adding the headers in the code. But it seems to not connect. I get the error "We couldn't authenticate with the credential provided". error.

The credential (API Key) was changed recently.