Skip to main content

Power BI

Needs Votes

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

Vote (167) Share
Elton Sequeira's profile image

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)
Elton Sequeira's profile image Profile Picture

Fjodors on 05 Jul 2020 23:16:34

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

Hi
We have the same problem.
We are using Web data source with authorization header and it works in PowerBI desktop version, however it doesn't work in PowerBI web (app.powerbi.com)

Elton Sequeira's profile image Profile Picture

Hubert on 05 Jul 2020 23:14:23

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

This is indeed required to fix urgently. Please fix it !!!

Elton Sequeira's profile image Profile Picture

Geoff Richardson on 05 Jul 2020 22:56:17

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

This is pretty terrible. Has anyone got a workaround to make it work in the Power BI Service?

Elton Sequeira's profile image Profile Picture

Thomas on 05 Jul 2020 22:56:12

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

Really need this! Otherwise no dashboard or report with the text analyses from the Cognitive services!