cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BjoernLueers
Advocate I
Advocate I

Authentication Method "Web API" not supported in Power BI Service

Currently the authentication method "API Token" does not seem to be supported in the Power BI Service. 

I used the ApiKeyName attribute from the Web.Contents method to declare the name of the header attribute. This worked perfectly in Power BI Desktop, i was asked to authenticate, clicked Web API and entered the API token. 

In the Power BI Service however there is no Web API Authentication method and I found no way to log in using the methods provided. 

Even worse is that i found no way at all to refresh the dataset in the service afterwards. Even hardcoding the API token into the the request URL did not work. The service would always ask for the API token:

"Failed to update data source credentials: A web API key credential is required when a web API key name is provided", even though I removed the ApiKeyName attribute and published the report with a different name in a different workspace. As if the Power BI service remembered that the source required an API token.

Only by using a different Power BI Service user I could finally resolve this. The message did not appear and I could authenticate anonymously.

3 REPLIES 3
v-diye-msft
Community Support
Community Support

Hi @BjoernLueers 

 

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
v-diye-msft
Community Support
Community Support

Hi @BjoernLueers 

 

It sounds like you need to specify an API key name in the headers area of Web.Contents using the advanced editor.  See Chris Webb's post on this for a good example: https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/.  

 

Here's another post probably helpful for you:

https://community.powerbi.com/t5/Desktop/Get-data-from-web-error-A-web-API-key-can-only-be-specified...

 

If the issue still exist , please kindly raise it to support team: https://powerbi.microsoft.com/en-us/support/

Support Ticket.gif

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Both of those approaches appear to involve hard-coding secrets into the PBIX file, which is not good from a security perspective. Anyone who gets the PBIX gets my secret.

 

I would expect that the PBI Service would manage the API Keys with the same approach as with Basic Auth, where the secret is write-only (only the service can get at it).

 

Jason

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors