Personal gateway data refresh failed

[nmichalesko]

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.

[v-shex-msft]

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

[v-shex-msft]

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

[nmichalesko]

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.