Forum Discussion
Personal Gateway
rl_evans, after you deploy your model in the service, you will need to go to schedule refresh section and specify credentials for each connection used by your model.. it is these credentials that the gateway will use to make connections to data sources.
If you pick Windows authentication, then the credentials that you entered into your Gateway are used to connect.
Yes, when installing Personal Gateway it prompts for credentials. These are the credentials under which the service runs. However, when one first attempts to schedule a refresh or refresh on demand, Power BI asks whether you want to use Windows Authentication or Basic Authentication. This potentially implies that the gateway uses a credential other than the one it is running with. If this is true then, which credential is it using? Since there are three different Window Authentication credentials at play:
- one for logging onto device
- one for logging onto Power BI
- one for launching Personal Gateway
Which one is the gateway using when it connects to the on-prem data source? The most logical is the gateway will connect to the data source using the credentials it is running under. I'm looking for confirmation.
There is a limitation to this approach. All reports that are refreshed using this device are forced to use this single credential. If other credentials are needed to refresh other reports, a different device needs to be set up with the gateway.
rl_evans, after you deploy your model in the service, you will need to go to schedule refresh section and specify credentials for each connection used by your model.. it is these credentials that the gateway will use to make connections to data sources.
If you pick Windows authentication, then the credentials that you entered into your Gateway are used to connect.