Bypass test connection/Ignore failure for Web Sources that depend on authorization header

[elton1]

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.

[lukas_krajnak]

Can this be fixed, please?

[jsteinigen1]

...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.

[leslie1]

Really disappointed and really need it to be fixed

[debznfoz]

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?

[david_cornwell]

This really needs to be fixed. Come on Power BI team!

[ronnylun]

'+1, please fix this

[mssql2014]

Please add this feature

[lucas_mendes1]

I need this too... in desktop it works, but in service it doesn't work

[gmaes]

We have just came across this too, voting for a fix to this issue.

[anderson_costa]

Common PwBi Team! I am trying to use PwBI + SharePoint REST API (That requires authentication upfront ).. the workaround of using relativepath won't work here!! Please, integration is the KEY that makes PwBI so great, and right now I am not able to connect TWO MICROSOFT PRODUCTS!!! fix it pls!