Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rl_evans
Helper II
Helper II

Personal Gateway

The documentation for Personal Gateway doesn't clarify what credentials will be used to authenticate against the data source.  Will it be the credentials the gateway is running under or the credentials used to log into Power BI online (assuming Windows Authentication was selected).

 

My situation is that some user's devices are in a different AD domain than the data source. The user is logged onto their device using the credentials for the domain the device is in.  The user then logs onto Power BI using their credentials that are in the same domain as the data source.  When the gateway is installed, it is configured to run using the user's credentials that are in the domain of the data source.  When the user goes to refresh the dataset for the first time, they are challenged to sign in using Windows Authentication.  What isn't clear is which credentials Power BI is now using to connect to the data source; the credential's used to log onto the device, the credentials used to log onto Power BI, or the credentials that the gateway is running under.

1 ACCEPTED SOLUTION

@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.

View solution in original post

6 REPLIES 6
Greg_Deckler
Super User
Super User

It will prompt you for credentials and it needs to be a "Microsoft or Work/Organization" account, the one that is tied to your Power BI service.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.


@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?

Anonymous
Not 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?

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?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.