Signing out of all Accounts affecting Gateway

[Imrans123]

Hi, 

Was wondering, if anyone tried to do this. I want to go to Microsoft 365 admin and sign out all sessions for a particular user. This user is logged in to a enterprise data gateway instance. If I change the password and sign out of all sessions, would I need to relogin with that account on the gateway?

[v-nuoc-msft]

Hi @Imrans123 

When you log out of all sessions for a user through the Microsoft 365 admin center, this action invalidates all access tokens associated with the user account across Microsoft 365 services. Within an hour or when the user leaves the current Microsoft 365 page, they will be prompted to sign in again.

Enterprise Data Gateway uses service accounts to maintain connections to local data sources. If the account used for the data gateway is the same account that is logged out from all sessions, it may affect the gateway's ability to connect to the data source until re-authenticated with new credentials.

If you change the password of a user associated with the enterprise data gateway and log out of all sessions, you may need to:

Update the credentials used by the Enterprise Data Gateway with the new password.

Re-enter your login information to re-establish the connection to the data source.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aj1973]

Hi @Imrans123 

the user won't be able to use the Gateway until he enters his new credentials.

[Imrans123]

Hi Amine, 

Just to clarify, I have the gateway setup on a computer that has SQL Server. I am using DataFlows to query from the SQL Server instance in the gateway computer. If I were to sign out of all sessions on M365 admin, would that dataflow refresh not work until I sign back in? 

If so, can I sign back in through the service, or would I have to physically go into the gateway PC and login on the gateway?

[aj1973]

The refresh still goes on regardless. it is when you want to add a source on the gateway in the service that you will be asked to re enter your credentials.

That's why it wiser to use Power Bi service account for refresh.