Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi guys,
I would need to know with which user my gateway is now really running?
Background:
The gateway was setup and configured with my organization account.
Now the gateway tells me (and thats what I also understand from documentation) that it is running as NT Service\PBIEgwService.
Which Account is now really grabbing the Data from the SQL?
My concern is data privacy and therefore we want to change it, if it really is running wiht my organization account.
If it is really running under the PBIEgwService Account everythings fine... i guess....
PS: I already tried changing the account to an service account but it keeps telling me that Username or Password is wrong (even tho I tried the account and it works fine in Office365 and Windows)
BR
Panic
Solved! Go to Solution.
Hi @Anonymous,
If you can work with the sql data source, you can try to use sql profiler to trace these request from power bi to find out the detail contents:
BTW, normally power bi will use the credentials which configured on gateway Datasource settings if you did not enable the UPN for SSO on your data source.
Manage your data source - Analysis Services#User names with Analysis Services
Overview of single sign-on (SSO) for gateways in Power BI
Regards,
Xiaoxin Sheng
Hi @Anonymous,
If you can work with the sql data source, you can try to use sql profiler to trace these request from power bi to find out the detail contents:
BTW, normally power bi will use the credentials which configured on gateway Datasource settings if you did not enable the UPN for SSO on your data source.
Manage your data source - Analysis Services#User names with Analysis Services
Overview of single sign-on (SSO) for gateways in Power BI
Regards,
Xiaoxin Sheng
To now which account is actually grabbing data from the SQL, please check the below
go to Manage Gateways > Gateway Clusters and select the Data Source under the Gateway and check the login credentials used to log into SQL for the data source
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
30 | |
18 | |
12 | |
8 |
User | Count |
---|---|
50 | |
36 | |
30 | |
15 | |
12 |