Forum Discussion

nmichalesko's avatar
nmichalesko
Frequent Visitor
8 years ago

Refresh Failed Data Gateway

I have the on-premises data gateway personal edition installed for a few of my data sets on a server loaded with Windows Server 2012 R2 Standard, however whenever I try to refresh any data sets, eith...
nmichalesko's avatar
nmichalesko
Frequent Visitor
8 years ago
  1. Yes, I did for two days last week on my desktop and then I started getting the error. The error continued when I tried to switch the gateway to the windows server.
  2. I'm refreshing MySQL databases with custom queries.
  3. Yes, this is a fresh intall of the data gateway.
  4. On the service under settings it says "online" in green and the box I am running it on. Credentials are all good as well.
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi nmichalesko,

 

I tested a lot. I can't reproduce your issue.

1. I would suggest installing a On-premises Data Gateway instead of the On-premises Data Gateway (Personal mode). 

2. Check the custom queries. Many modeling steps can be done in the Query Editor. Try to delete these custom queries. 

This post could help: Enterprise-gateway-quot-cannot-connect-to-the-mashup-data-source

 

Best Regards!

Dale