Forum Discussion
Windows vs oAuth2 authentication to Sql Server
aj1973 well explained comparison, thanks.
Considering the scenario of using these methods in a Gateway connection I still have some doubts which one to choose. It is mentioned... (https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql)
Does it mean that oAuth2 i not recommended for this case? How long is the token valid? What i am afraid of is the token could expire before (in case of import), data refresh process is finished. As a result the refresh could be interupted.
What about second question:
2. Is that a good practice to use Azure AD account like [email protected] in Win or oAuth2 in such connection?
The connection way doesn't depend on what do you prefer, it depends on the organization policy applied for this type of connection.
If you don't want to ask your organization then it doesn't hurt to try.