Forum Discussion

JulieKucher's avatar
JulieKucher
Frequent Visitor
8 months ago
Solved

IS the problem in gateway or credentials?

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 connectio...
Need Help
  • MFelix's avatar
    MFelix
    8 months ago

    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.

     

     

cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
8 months ago

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