cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mcmum01
Helper I
Helper I

Gateway is configured correctly but is unreachable due to local network

Having trouble with on premises data gateway (personal mode) staying connected. The scheduled refresh ran for a couple of weeks without issue until this week. See the refresh history below:

 

History.png

 

 I started the Gateway app and see this:

1st Status.png

After I sign in, it looks like this:

 

2nd Status.png

 

How does it work for weeks and then suddenly stopped? I am not the administrator on the machine. I have been in the office and connected to VPN when I work from home multiples times in the 2 weeks and no issues. I saw lots of posts about this subject but didn't see a solution that would work for me. Any ideas?

 

1 ACCEPTED SOLUTION
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @mcmum01,

 

Please update your on premises data gateway (personal mode) to version 3000.0.144.3 and try again.

 

By my tests with the latest version, everything works as expected.

 

 

gateway.PNG

 

 

 

 

In addition, please check if your VPN is connected successfully. 

 

I'm not clear if you have had a reference of this similar thread, if not, you could have a try.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
corey_hallisey
Regular Visitor

On Friday, we had this problem his all THREE of our Power BI gateway servers - sandbox, qual, and prod.
In the Logs, we found the error 

[DM.GatewayCore] Swallowing non-fatal exception encountered during attempt 2271/2147483647 for startup of Transfer service: System.ServiceModel.CommunicationException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.IO.IOException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.Authentication.AuthenticationException: The remote certificate is invalid according to the validation procedure.

Turns out that on our 3 servers, we had a missing/expired cert for microsoft.powerbi.com

Once we installed a fresh cert on the 3 servers, things were working again. 

To test whether or not you have missing / invalid certs on your Power BI Gateway server:

1. Open a web browser on the gateway server.

2  Navigate to PowerBi.com

3.  Look for any Certificate errors warnings at top of the browser (usually they appear in RED).  

 

If you encounter these cert errors, you need to download an install a fresh cert from the certificate authority. 

James-Hinton
New Member

I am having the same problem with with the enterprise gateway.  It has been working well for a long time but since updating to Version 3000.63.6 (October 2020 release 2) I get the same error message when signing in to the gateway.

 

I also have the same version and the same situation. Please help.

v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @mcmum01,

 

Please update your on premises data gateway (personal mode) to version 3000.0.144.3 and try again.

 

By my tests with the latest version, everything works as expected.

 

 

gateway.PNG

 

 

 

 

In addition, please check if your VPN is connected successfully. 

 

I'm not clear if you have had a reference of this similar thread, if not, you could have a try.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

That did work, thank you. My concern is that is a short term fix, unless the previous release had a bug in it. I just couldn't understand why it worked for 90+ days and then suddenly stopped. 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors