Forum Discussion

F_Reh's avatar
F_Reh
Icon for Post Patron rankPost Patron
1 year ago
Solved

Unable to update connection credentials. The on-premises data gateway's service account failed...

Good Afternoon,   Kindly advise to help me get to the bottom of what's going on here:       Its linked to SQL Server connection(s) I have in this section:     It was working prev...
  • v-pnaroju-msft's avatar
    1 year ago

    Hi F_Reh,

    Thank you for your follow-up.

    To clarify, when I mentioned "Change Account" in Step 2, I was referring to the Windows service account that operates the On-premises Data Gateway, and not your Power BI admin email or SQL Server connection credentials. This action must be performed on the server or machine where the gateway is installed, using the On-premises Data Gateway application.

    Kindly follow the steps mentioned below to change the Gateway Service Account:

    1. Open the On-premises Data Gateway application on the machine where it is installed.
    2. Navigate to Service Settings and click on "Change Account".
    3. Enter the domain service account credentials (for example, DOMAIN\GatewayService) which should be provisioned with a non-expiring password.

    Please refer to the following link for more detailed information:
    Change the on-premises data gateway service account | Microsoft Learn

    Please note that this procedure does not affect your Power BI administrator account. That account continues to be responsible for publishing and managing reports. The service account is used solely to run the gateway and securely connect to on-premises resources such as SQL Server. Using a service account ensures a stable and uninterrupted connection, even after personal password changes.

    If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members encountering similar queries.

    Should you have any further questions, please feel free to contact the Microsoft Fabric community.

    Thank you.