Power BI
Needs VotesBypass test connection/Ignore failure for Web Sources that depend on authorization header
Elton Sequeira on 09 May 2017 00:55:48
The power BI service runs a test connection on Web API data sources before pulling data. However for Web Sources whose response depends on a required authorization header fail to authenticate in the power bi service while setting up a scheduled refresh. The source is accessed using Web.Contents and by passing the URL, Relative path and authorization header. This works perfectly fine in Power BI desktop since it executes the GET request along with the authorization header without a test connection. If the same could be done in power bi service by either bypassing the test connection or ignoring failures then a schedule refresh could be setup.
- Comments (24)
RE: Bypass test connection/Ignore failure for Web Sources that depend on authorization header
I have exactly the same problem. Ive implemented Text Analytics and it works fine in Desktop. However, when you go into Datasets Data Source Credentials you get Failed to update data source credentials: Web.Contents failed to get contents from 'https://westus.api.cognitive.microsoft.com/text/analytics/v2.0/keyPhrases' (404): Resource Not FoundHide details Not only does this need to be fixed but Help. What is the workaround?
RE: Bypass test connection/Ignore failure for Web Sources that depend on authorization header
Really disappointed and really need it to be fixed
RE: Bypass test connection/Ignore failure for Web Sources that depend on authorization header
...and more than a year later it's still a persisting issue. WHY?! Can't be that hard to fix. It's already working in Power BI Desktop.
RE: Bypass test connection/Ignore failure for Web Sources that depend on authorization header
Can this be fixed, please?
RE: Bypass test connection/Ignore failure for Web Sources that depend on authorization header
There is a way to "bypass" using the azure proxy but comes at a cost which is not ideal.... This is something that should just work.
https://blog.kloud.com.au/2018/07/23/use-anonymous-authentication-on-web-data-sources-with-a-api-key-in-url/
RE: Bypass test connection/Ignore failure for Web Sources that depend on authorization header
Has anyone found a work around for this extremely disappointing issue?
RE: Bypass test connection/Ignore failure for Web Sources that depend on authorization header
'+1, please fix this
RE: Bypass test connection/Ignore failure for Web Sources that depend on authorization header
We also need this fixed urgently.
RE: Bypass test connection/Ignore failure for Web Sources that depend on authorization header
Agree, that a fix for this is needed. I have tried to understand for months why reports created in Desktop using Web API data sources can be refreshed OK, but cannot be scheduled for refresh in PBI service. I finally came across this thread today, and hope that something can be done.
RE: Bypass test connection/Ignore failure for Web Sources that depend on authorization header
This feature is really missing in power bi service. It does not allows us to publish and Schedule reports using API such as Microsoft cognitive services.