Forum Discussion
jasonyeung87
4 years agoHelper V
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 var...
- 4 years ago
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/
nitishsh91
4 years agoSolution Supplier
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
3 years agoHelper V
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.
- EdwngJs1 year agoRegular Visitor
Hello, Could you please show step-by-step how you did?
Thanks