Forum Discussion
Post PatronChanging Passwords on Gateway Connections
For the last 3 times my password has changed per company policy, I have had to go in and create all new connections for my gateway online. When I try to update the password for any connection in question, it gives me a "Unable to update connection credentials. Invalid Connection credentials." It really is a huge pain to have to manually create new ones each time.
What can I do to fix this?
kattlees
Generally, power bi support requests can be raised through power platform admin center
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticketIf the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
4 Replies
- tharunkumarRTK
Super User
You can upadate the credentials of an exisiting on premises gateway connection and it should not throw any error. You dont need to create a new connection every time. What is the data source type?
I would suggest you to raise this case with Microsoft support team if you are not able to update the credentials of an existing connection.You can also automate the processing of updating the credentials using Power BI rest apis:
https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/update-datasource
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
kattleeshow do I raise the case with Microsoft support?
- tharunkumarRTK
kattlees
Generally, power bi support requests can be raised through power platform admin center
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticketIf the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
luke-novacekHelper I
In case someone finds this now: the portal still updates credentials one connection at a time. The documented way to script it is the Power BI REST API (Gateways - Update Datasource), but:
- the credentials have to be encrypted with the gateway's public key first
- that call keeps no readable copy of the username, so the portal stops showing it afterwards
This comes up so often that I built a free, open-source tool for it: GatewayLens (I'm the author).
- Filter the connections by the account.
- Type the new password once.
- It updates every listed connection the way the portal does, then tests each one.
About third-party tools and passwords - a fair point. GatewayLens runs only on your PC and signs in as you. It encrypts the password with the gateway's own public key before it leaves your PC, talks only to Microsoft, and stores nothing. The code is open to read: GatewayLens on GitHub