Skip Test Connection option is missing

[RZXGAMER]

The option "Skip Test Connection" in data set settings is missing . I used before, but today when i try to use a new API source, i can't find the option to skip test connection. And as it is a two step authentication API, i can't update the report through the platform.

[v-yuta-msft]

@RZXGAMER ,

If your data source is on-premises data source, please update gateway to the latest version. Please see announcement below:

https://powerbi.microsoft.com/en-us/blog/skip-test-connection-for-on-premises-and-cloud-data-sources...

However, it seems like that some cloud source are not supported currently. The workaround is not to use the root url, you can use web.content to contain your credentials like access token.

Regards,

Jimmy Tao

[bhen]

Hi Jimmy Tao,

could you be a bit more specific about the web sources? I have used the "Skip Connection" for all of my reports that use JWT token auth and this is a big problem for me now.

This is how I connect in the PBIX:

let contracts = let GetJson = Json.Document(Web.Contents("https://source.com/api/login", [Headers=[Accept="application/json", #"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"], Content=Text.ToBinary("[email protected]&password=aPassword&grant_type=password")])), data = GetJson[data], access_token1 = data[access_token], source = Web.Contents("https://source.com/api/entity", [Headers=[Authorization="Bearer"&access_token1, ContentType="application/json"]]),

It worked fine before yesterday, now I cannot get a new report to work. Thanks for any tip.

[Anonymous]

@v-yuta-msft 

Can you elaborate on what you mean?  We also have reports that rely on the "Skip Test Connection" setting.  They currently still work (because it looks like the option is still enabled on the back end) but we are unable to create new, or modify existing, reports.  I have tried what you suggested and it doesn't seem to work.

[Anonymous]

Agreed.  This is a breaking change for us

[TMG-Marcel]

Try changing your URL to https://app.powerbi.com/home?skipTestConnection=true

[Anonymous]

@TMG-Marcel You're a hero, Thanks for sharing

[jacknoble]

@TMG-Marcel I tried this and the "skiptestconnection" part stayed on the end of my URL while I was navigating the site, but it still tried to test my connection when I added credentials to the datasource. Is there anything else that needs to be done for this to work? 

[TMG-Marcel]

@jacknoble Do you see the checkbox option to Skip Connection Test?

It should look something like this in your data source credentials setup:

From what I see, the URL query parameter skipconnectiontest is no longer required. All the parameter did was re-enabled the Skip test connection checkbox.

[jacknoble]

@TMG-Marcel thanks for getting back to me so quickly. My issue turned out to be due to me installing the wrong type of gateway. I corrected that and I can now see the "skip test connection" box when configuring access to a data source again. Thanks!

[Marco74]

We have the same issue but despite being up-to-date with both our PowerBI and gateway version we do not have the 'skip test connection' checkbox under datasource settings.

Is there another way to solve this problem?