Forum Discussion
Authentication selection for connection sharing
Yes, you can switch/use to Windows authentication for your existing connections. In Power BI Service, update the data source settings to use Windows authentication. Users will connect using their own Windows credentials, so they don’t need your credentials.
Use a dedicated service account for the gateway to avoid disruptions when employees leave. This account should have the necessary permissions and won’t be affected by individual employee changes. Meaning the gateway should run under a service account that has access to the SQL Server database.
If your personal credentials were used, an admin will need to update the data source settings with new credentials.
Hope this helps!!
- If you used Basic Authentication (username and password), the credentials are stored with the connection. This is generally not ideal for sharing, as it can lead to security risks if credentials are shared directly or exposed.
- Windows Authentication (or Active Directory) is typically more secure and is the preferred method
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn