Forum Discussion

nmichalesko's avatar
nmichalesko
Frequent Visitor
8 years ago

Personal gateway data refresh failed

I have the on-premises data gateway setup on a Windows Server running 2012 R2 Standard. I made sure to uninstall the enterprise gateway to see if that would make a difference with this error. Whenever I attempt to refresh the data from the cloud Power BI service, either manually or scheduled, I'm getting the error message:

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

Underlying error code: -2147467259

Any idea what's going on?

Thanks in advance.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI nmichalesko,

     

    Based on error message, it told that can't connect to the data source. Which type of datasource your used? Can you please provide more detail contents?

     

    Regards,

    Xiaoxin Sheng

    • nmichalesko's avatar
      nmichalesko
      Frequent Visitor

      I'm connecting to a mysql database and using a custom sql query. The refresh works fine on the power bi desktop. Refreshing worked fine twice last week on my desktop but then suddenly stopped working on my desktop. Refreshing will still not work from the gateway once I installed it onto a windows server.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi nmichalesko,


      I can't reproduce your issue, both two refresh all work on my side. Can you ensure any setting changes on your server device?

      In addition, you can also check the mysql service state.

       

      Regards,

      Xiaoxin Sheng