Forum Discussion
OData feed editor: A web API key can only be specified when a web API key name is provided
I want to connect to an OData feed by using an Web API key for authentication. The obvious way is to choose "Get Data"/"OData Feed" and use the editor. After I entered the URL I need to choose how to authenticate. Because I have a API key I chose "Web API", entered the key and hit "connect" --> Error.
I'd really like to specifiy the API key name - but how? The dialog in this case doesn't work as designed and is of no use. We always need to use a workaround.
2 Replies
Hi Sokon,
You can pass ApiKeyName in the OData.feed() use Power Query. For more information, see:
authenticating with Excel Power Query against .Net Odata Web Api
API Strategies with Power BIBest Regards,
Qiuyun YuIs there no way to specify the ApiKeyName without having to resort to writing the OData.feed() function yourself in Power Query? This might be fine for technical users, but isn't a great experience for business users. With OData feeds using basic authentication, everything can be done in the UI/Wizard (no need to write the function expression). But when an OData feed uses an API key, the UI/Wizard is useless... why can't Microsoft simply expose the ApiKeyName parameter somewhere in this UI?
