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...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi nmichalesko,

 

1. Did you refresh successfully under these conditions before?

2. What kind of datasets do you want to refresh?

3. Did you upgrade the gateway to the latest On-premises data gateway (personal mode)?

4. What is the stutas of the gateway in the Power BI Service? And the credentials?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

 

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