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, either scheduled or manual, I'm getting the following error:

Cannot connect to the mashup data source. See error details for more information.

 

Underlying error code: -2147467259

 

I'm running the refreshes from the cloud Power BI service. Any idea what's going on?

Thanks in advance.

3 Replies

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