Forum Discussion
Personal Gateway
- 11 years ago
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.
- anywhereanytime10 years agoHelper III
We are a Microsoft BI Partner and we have our own Power BI 2.0 licenses. With a customer, who sets up a Personal Gateway "within their domain" is it possible "to Get Data" from THEIR persoanal Gateway INTO "our" Power BI Desktop, even though our domain is "dirfferent"?
Working with the customer yesterday, we successfully "intalled the personal gateway" but never saw any "configuration wizard" that the documentation suggests?
How do we "trigger' this "Configuration Wizard" with the Personal Gateway?
- mcarper10 years agoRegular Visitor
andre wrote: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.
For Windows auth, where do you enter the credentials for the Gateway? When configuring it, the only credential I enter is the Power BI account. When I go to the relevant Dataset settings, I can select Windows authentication for it, but I can't pick which Windows account. Am I basically "stuck" with the Windows account that the Personal gateway is installed on?
- Anonymous8 years agoNot applicable
Hi there, I also experience my Power BI credentials got stuck in Data Gateway (Personal) instead of other creads I keep on trying to save under "Data Source Credentials" in Power BI Service...The result is Failed to update data source credentials: The credentials provided for the Web source are invalid.
Have you got a chance to found a solution?