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...
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 BI
Best Regards,
Qiuyun Yu
Is 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?