Forum Discussion
Dataset refresh failure- Cannot connect to mashup data source
Updating the gateway on the server it was setup on resolved the issue for me
I have the same problem.
In my case, one difference is that gateway connection used to work fine, until it didn't. That is, this report was using the refreshed update 8 times a day without any problems. Now it doesn't work, I have to manually update the model on the service.
details of the error point me in the direction of a failed conversion :
Though that does raise some questions. Wouldn't it fail also on PBI desktop ?
Why is the behavior different through the gateway than it is on my model on PBI desktop ?
Gateway works fine for other reports on direct query on the same tables.
How old is your On-Premise Data Gateway version? Have you updated it recently?
From a network perspective, how far away is your Gateway from your Data source? Is it much further away on the network than the machine doing the desktop refreshes?
What time is your gateway doing its refreshes? Is that time different to when you do your desktop refreshes? Is the time of day a factor in your servers performance? For example, are you trying to refresh the gateway during a peak period when the server is overloaded?
Thank you Ross.
=> I do not manage this gateway, but I have the exact same issue when I choose another gateway, running on my VM. This one is less than a year old, and wasn't updated recently.
=> From a network perspective, my gateway is in the same locker as my DataSource, whereas when I call it from my laptop, i'm a couple of kms away.
=> I scheduled 8 daily refresh, during business hours (0800 to 1800) all of them fail withou exception. I refresh it on my desktop at the same time. Same problem arises when I refresh the dataset manually from the PBI service
Regards,
Etienne de Villers
Hi
Did you manage to have this issue fixed?
Having the same issue
