Received error payload from gateway service with ID 349279

[DianeL]

I recently changed my password and i'm no longer able to connect and i'm receiving the following error message:

Unable to update connection credentials. Logging into Sql server failed. Possible reasons for this error include an invalid authentication mode, a missing login in Sql server, a login from an untrusted domain or a problem contacting the domain controller for the authentication request.

Details: [GatewayName]: Received error payload from gateway service with ID 349279:

I've uninstalled/resinstalled the gateway many times, as well as restarted the gateway to no avail. 

[DianeL]

@pborah @v-sgandrathi Thank you both. To clarify, all of our agency's products including all microsoft products (SQL & PowerBi) rely on our network SSO. When I change my pw (every 90 days), I have to update my connections with the new pw. In the past 5 years of using PowerBI I've never run into this issue. 

The issue still persists. I've uninstalled and reinstalled the gateway. The gateway is online. However, my connections to the servers are still generating the error message. My IT department is also looking into a solution as well, but it's been 2 weeks. 

[v-sgandrathi]

Hi @DianeL,

Thank you for providing the information. To address this issue effectively, we recommend submitting a support ticket. This will enable the product team to conduct a detailed investigation and track any potential changes in your environment or configuration that may be contributing to the error.

To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.

Thank you for being a part of Microsoft Fabric Community Forum!

[v-sgandrathi]

Hi @DianeL,

Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you for your understanding and assistance.

[v-sgandrathi]

Hi @DianeL,

Thankyou @pborah for your response.
I wanted to check if you had the opportunity to review the information provided by community member . Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you for using Microsoft Community Forum.

[DianeL]

@pborah Thank you so much for replying. I should have been more specific, I updated my organziation's signle sign-on (SSO), as we must update it every 90 days. My ODBC connections and SQL server are all reading my new password. I am able to pull the data fine. I'm also able to connect on the PowerBI Desktop. The issue with managing the connections online. 

[pborah · Accepted solution]

@DianeL Thanks for the clarification. I'm not sure SSO/kerberos works for import mode in Power BI service if you are using Windows authentication as it still requires you to type in a user-name and password for the specific gateway connection. There are options to check-off SSO for direct query a few different ways however. We use basic authentication for our on-prem SQL sources which is a lot easier to manage. In SQL we have dedicated service accounts for PowerBI. In any case, I hope the following articles helps you somewhat- 

https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-sso-kerberos

[pborah]

@DianeL Have you tried recreating the connection to your SQL source in the gateway with the new password? Also, while I think I know the answer, by changing password do you mean you changed the password of the SQL login used to connect to the data source in SQL from PowerBI?