Forum Discussion
Authenticating OData.Feed using Web API difficulty
In that case, I'm moving this thread to Authenticating OData.Feed using Web API difficulty - Microsoft Fabric Community
Community SupportHi albabae ,
Thank you for engaging with the Microsoft Fabric Community. This issue is happening because Power BI’s Web API option needs both the API key and the key name. But in the UI, there’s no place to enter the key name, so it throws that error.
That’s why it works with Basic auth but not with Web API. As a workaround, you can use M code and pass the API key manually either in headers or as a query parameter. That gives you full control and avoids this limitation.
If you manage the API, you can also allow the key in headers, which works more smoothly with Power BI.
I hope this clarifies the situation. If I’ve misunderstood any part of your situation, please let us know.
Yes. Thank you. This is seeming like the current workaround. But it's kindof a hassle. If you can expand on
> you can also allow the key in headers, which works more smoothly with Power BI.
That would be appreciated. I currently allow headers like "Bearer token" or "x-api-key" request header. I also allow basic auth and url query parameter.
Also where would I go to suggest such a feature in the UI, to have the api key name? I found giving feedback to microsoft for power bi is kinda difficult and a hassle.
- V-yubandi-msft
Hi albabae ,
You can share your feedback on the Fabric Ideas portal here: Fabric Ideas - Microsoft Fabric Community.
The product team regularly reviews suggestions there and considers them for future improvements.
Thanks.