IS the problem in gateway or credentials?

[JulieKucher]

Hi ,

I am using Azure SQL for the report and it is in import mode. I need to set up a scheduled refresh. However, I get error in the Settings page, the errors says : "Failed to test the connection". Why would that appear? What should I do to set up the refresh? I am using the same credentials I used in logging into Azure SQL, but why it would say : " failed"? Do I need to create a gateway for ths from the scratch ? 

[v-nmadadi-msft]

Hi @JulieKucher 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @JulieKucher 

I wanted to check if you had the opportunity to review the information provided by @cengizhanarslan and @MFelix . Please feel free to contact us if you have any further questions.

Thank you.

[cengizhanarslan]

If you see “Failed to test the connection”, it means the Service cannot authenticate or reach the database, even though Desktop can.

• If you used Azure AD (MFA) in Desktop, it will often fail in Service.

• For scheduled refresh, use:

  • Azure AD – Service Principal (recommended), or

  • SQL authentication (username/password).
    MFA user accounts are a common reason for “Failed to test connection”.

[MFelix · Accepted solution]

Hi @JulieKucher ,

To what I can understand from your post you have a connection trough a gateway correct? Did you create the connection string in Power BI Service?

If you have check if on the gateway of the semantic model you have the correct connection selected.

When using a gateway the credentials come from the gateway connection so the problem may be on your connection.

Go and double check if the connection string is making the correct login.