March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
39 | |
22 | |
21 | |
10 | |
10 |
User | Count |
---|---|
60 | |
56 | |
22 | |
14 | |
12 |