cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CoV Frequent Visitor
Frequent Visitor

Unable to connect: The gateway is either offline or could not be reached - DM_GWPipeline_Client_Gate

Hi,

 

I've installed the Power BI Gateway service successfully, configured a gateway, created a datasource and everything looked good.

 

I changed the service account that runs the Power BI Gateway service from NT SERVICE\PBIEgwService to a domain service account, I refreshed the connections in app.powerbi.com, I get the following error:

 

Unable to connect: The gateway is either offline or could not be reached.
Activity ID: 67a30327-2fc0-376d-0505-a0ff91a1e5bc
Request ID: 4980dee0-d7ff-4c01-a299-4bfbd961b7d9
Cluster URI: https://wabi-west-us-redirect.analysis.windows.net
Status code: 400
Error Code: DM_GWPipeline_Client_GatewayUnreachable
Time: Thu May 05 2016 12:08:12 GMT-0700 (Pacific Daylight Time)
Version: 13.0.1100.480

 

I've restarted the service (successful, no errors in event logs), I've ensured the domain service account has the "log on as a service" permissions, I've uninstalled, downloaded the latest GatewayServiceInstaller, installed it, it worked when running under NT SERVICE\PBIEgwService but breaks when I change the service account to a domain level account.

 

thoughts..?

3 REPLIES 3
Pedzilla Member
Member

Re: Unable to connect: The gateway is either offline or could not be reached - DM_GWPipeline_Client_

Hi
Have you tried to download and install the latest version which was released this pass weekend?
There's the Effective user map feature that may resolve your problem?
CoV Frequent Visitor
Frequent Visitor

Re: Unable to connect: The gateway is either offline or could not be reached - DM_GWPipeline_Client_

Thanks for the reply...

 

Uninstalled, downloaded the latest, installed and it worked out of the gate under the NT SERVICE\PBIEgwService service but as soon as I change it to a domain account, it errors out with the error message above.

 

looks as though the user mapping you're referring to is marrying up users cloud identities to user accounts\roles on the SSAS models themselves or subset of data within the model.

 

I'm looking to change it so the service runs under a domain level account vs a local account.

 

thoughts..?

 

UPN Mapping

Starting today, customers using Analysis Services with the Power BI Gateway will be able to set up their own UPN mapping rules. UPN Mapping enables gateway admins to apply custom security rules by mapping users’ cloud identity to specific on-prem roles or identities, via Effective User name and CustomData properties on an AS connection.

This feature will be rolled out in 2 phases: Using Effective User name, which is now available, and using CustomData property, which will be available soon.

To start creating new mapping rules, you need to go to the “Manage Gateways” option from your Power BI dashboard, and then choose the Gateway and Analysis Services server to which you want the rules to be applied.

Click on the Users tab and notice the new “Map user names” option. This will open the UPN mapping rules pane and you can start creating rules, changing their order, and testing the user names that you’d expect to change based on the rules. These rules will be applied to the selected data source only and not the whole Gateway. Please note that you need to be a Gateway Admin to set up or modify these rules.

jbre03 Frequent Visitor
Frequent Visitor

Re: Unable to connect: The gateway is either offline or could not be reached - DM_GWPipeline_Client_

How would I get to the users tab, to access the mapping user name option, when I'm creating a new SSAS dataset and it throws the following error?

 

Unable to connect: We encountered an error while trying to connect. Details: "We reached the enterprise gateway, but the gateway can't access the on-premises data source."

Error Code: DM_GWPipeline_Gateway_DataSourceAccessError

 

I am unable to add the dataset because of this error and there is no user tab available until after the dataset has been created 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)