Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We're trying to connect to an API that requires both basic auth and a custom header called "clientid".
The data source is configured with basic authentication, and the clientid header is passed through with the web request, like this:
Source = Web.Contents("...", [Headers=[clientId="..."]])
When configured in this way, Power BI refuses to even execute the API call, giving the error:
clientid header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Referer
So it would seem that Power BI has a safe list for headers that can be used with authentication, and anything that falls outside that is blocked? Assuming there's no other way to inject a custom header into an authenticated request, this means that there's no way for us to make a request to APIs with these requirements.
Is there any way to make a request like this successfully?
(There is a similar post over here that never got a satisfactory response - to be clear, turning off authentication is not an option!)
Hi @mikegoatly ,
Based on my research, there is no way to keep the custom header with basic authentication in basic web connector (As the error message say), here is a similar post.
You can come up a new idea and add your comments there to make this feature coming sooner. https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I figured as much, but thanks for confirming.
For reference I've createed the idea here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38624035-allow-custom-headers-for...
Kind regards,
Mike
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |