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!!
Hi All,
Thanks for your replies.
If I use windows authentication do I need to give my windows credentials to connect to the database and then share this connection to other users ?
Please suggest
Hi viswaaa For windows authentication, you need to provide, server name, database name, user name and password.
You can find windows user name by executing sql statement : Select SYSTEM_USER;
or using task manager. Password is your login password.
Hi shafiz_p ,
I have 2 questions here
1.)Can I still use this windows authentication for our existing connections and share the same connections to users.Will this work ?
2)If I use windows authentication and I left organizationtomorrow.
I think this credentials has to be change right ?
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!!