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

    Daniel on 06 Jul 2020 00:08:27

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

    Datasources on the web have many forms of authentication and authorization. Fortunately, mquery allows us to craft unique queries to accommodate those different methods. Unfortunately, Power BI service does not. Until skip connection test is back online many web datasources are offline for Power BI..

    Elton Sequeira's profile image Profile Picture

    Alex Bjørlig on 06 Jul 2020 00:07:42

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

    Wow - any ideas for a workaround?

    Elton Sequeira's profile image Profile Picture

    Brett Griffiths on 06 Jul 2020 00:07:10

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

    '+1 please fix, such a neg to the product.

    Elton Sequeira's profile image Profile Picture

    Nathan on 06 Jul 2020 00:04:58

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

    Lost 4 hours today on this issue thinking the problem came from my query...

    Elton Sequeira's profile image Profile Picture

    Anderson on 05 Jul 2020 23:58:06

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

    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!

    Elton Sequeira's profile image Profile Picture

    Geoff on 05 Jul 2020 23:53:22

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

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

    Elton Sequeira's profile image Profile Picture

    Lucas Costa Mendes on 05 Jul 2020 23:51:39

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

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

    Elton Sequeira's profile image Profile Picture

    Dmitry on 05 Jul 2020 23:50:10

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

    Please add this feature

    Elton Sequeira's profile image Profile Picture

    Ronny on 05 Jul 2020 23:44:44

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

    '+1, please fix this

    Elton Sequeira's profile image Profile Picture

    David Cornwell on 05 Jul 2020 23:39:31

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

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