Forum Discussion
How to differentiate Power BI users when making connection in sql server using same gateway.
Hello Friends, Hope you are doing well. Before putting the real requirement, let me explain some back ground of the requirement. I am working on Power Bi reports from last couple of Months. ...
Within one gateway, you can only create only one data source for one SQL Server database(servername/dbname). Even with different credentials(user/password), The data sources will be identified as duplicated.
There's no any "create new gateway" button, to create a new gateway, you just download the gateway and configure it after installation.
By the way, what is your scenario to have connection with different users. If for audit purpose, maybe you can check Using auditing within your organization.