Forum Discussion
PBI Service Refresh Error -A web API key credential is required when a web API key name is provided
Hi BIAnalyst907 ,
Have you gone through the details of what is mentioned in this error message and the relevant documentation provided?
There may be a solution to this problem. You can also show me the details so that I can better understand your error.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Isn't it obvious what he means? In Power BI Desktop you get 4 authentication methods, one of them is WebAPI. Desktop asks for the key and refreshes correctly.
But when you deploy the same report to Power BI Service and are asked to enter credentials when setting up scheduled refresh, there is no WebAPI on the list. You get "Basic", "Anonymous" and "OAuth".
Since you are asked to enter credentials when setting up refresh, the question is: what to enter? Which authentication method to choose since WebAPI is missing?
Hardcoding an API key in M query (pbix) - even if it worked - defeats the [security] purpose really.