Configure Web API with only username for Basic Authentication in Service

[Anonymous]

Hi Community,
Does anyone know how to configure Web API in Service using only username (API key)? I am able to get it working in the desktop version but when publishing it to service for refresh, I couldnt get it working since the Credentials setting screen requires password. I have tried to enter the same password as the username but still no luck. Any thoughts or comments would be really appreciated!

[Anonymous · Accepted solution]

Hi @Anonymous ,

To my knowledge, Power BI service does not support the ApiKeyName option.

And if the root URL of the your api works with anonymous access, you can publish the report that uses the Headers option to pass an API key and the refresh should work in Power BI Service. However, if your root URL returns error with anonymous access, refresh in Power BI Service will fail.

Please refer to the following threads:

https://community.powerbi.com/t5/Service/Data-refresh-with-Web-Contents-and-Web-API-authentication/m-p/1621430

https://community.powerbi.com/t5/Service/API-authentication-error-on-scheduled-refresh/m-p/744469

https://community.powerbi.com/t5/Service/Anonymous-access/td-p/19136

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.