Forum Discussion
Post PatronUnable to update connection credentials. The on-premises data gateway's service account failed...
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:
- Open the On-premises Data Gateway application on the machine where it is installed.
- Navigate to Service Settings and click on "Change Account".
- 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 LearnPlease 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.
Community SupportHi F_Reh,
We sincerely appreciate your enquiry through the Microsoft Fabric Community Forum.
Based on my understanding, the issue arises because Power BI attempts to authenticate the SQL Server data source using your Windows credentials. However, since your Windows password was recently changed, the saved credentials used in the gateway connection have become invalid.As you are using your personal Windows login, each time your password changes, the data source connection fails until the credentials are manually updated.
To avoid such recurring failures, the recommended solution is to use a dedicated service account.
Kindly follow the steps mentioned below, which might help resolve this issue:
- Create a Service Account and request your IT team to provision a domain account with the “password never expires” setting.
- Open the On-premises Data Gateway application, navigate to Service Settings, and then select Change Account. Configure the newly created service account here.
- Update the Data Source Credentials in Power BI by accessing Power BI Service, followed by Manage Gateways. Select the relevant data source and enter the service account credentials.
By using a service account, you will disconnect the data connections from individual user credentials, thereby ensuring stable and uninterrupted access even when personal credentials are changed.
If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar issues.
Should you have any further queries, please feel free to contact the Microsoft Fabric Community.
Thank you.