Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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