Forum Discussion
Enter credentials for Web API when publishing to Power BI Service
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?
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/
4 Replies
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/
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.
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.
Hello, Could you please show step-by-step how you did?
Thanks
