Refresh Failed Data Gateway

[nmichalesko]

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.

[v-jiascu-msft]

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]

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]

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