Forum Discussion

rorolpe's avatar
rorolpe
Regular Visitor
10 years ago

failed to update data source credentials

Hi! I´m new here and I have a problem with Schedule Refresh of an excel in PowerBI. We have a gateway personal that is online: Our excel has two data connections, one of them is working ok but...
Comment
Suggestion
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Looks like a Microsoft SQL Server, correct? First, are you certain that the SQL server is enabled for Windows authentication? Are both of these connections going to the same server or to different servers?

  • rorolpe's avatar
    rorolpe
    Regular Visitor
    10 years ago

    Thanks smoupre for answer me.

    Yes, Data conection is an Microsoft SQL Server.

    Yes, Our SQL Server is enabled for Windows authetificacion because we use Active Directory.

    And Yes, both of our connectios is going to the same server.

    With the first connection, I edit credentialas correctly

    And our problem is with another connection...that is "Thinking" but suddently told us :

    "Failed to update data source credentials"

    I tried to open my excel and "update connections" and it is working ok.

    But, we think the same process is in PowerBI, but isn´t:

    We don´´t know what would be the problem for this connection and we need that this works to schedule refresh.

    Please help me