Skip to main content

Power BI

Needs Votes

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

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

55b0a887 0f9c-4e74-80e9-318dd3576f20 on 05 Jul 2020 23:18:18

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.

Elton Sequeira's profile image Profile Picture

3cc06566 f5f1-46b7-b2d5-1bed0246d97e 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

62adc212 fe00-4635-a19f-9eb8bf6ccde2 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

a2ec1974 a898-4655-b473-8712bcfa392c 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

2872e224 6a7e-4027-98f6-7bd2fc89c9d3 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!