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.

[Nathan_Benichou]

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

[brett_griffiths]

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

[ab3]

Wow - any ideas for a workaround?

[fbcideas_migusr]

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