Forum Discussion
Dataset refresh failure- Cannot connect to mashup data source
Hello All,
I have published a report to power BI online from Power BI desktop. Refreshing the data works fine in Desktop but it doesn't work in Power BI online. Gateway is always online as it is installed in a virtual machine which always up and running. Manual refresh or scheduling refresh gives me the below error:
Something went wrong
Cannot connect to the mashup data source. See error details for more information.
Please try again later or contact support. If you contact support, please provide these details.
Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity IDae950f85-cf93-4395-93d8-8f144537ea5d
Request ID22b24433-5f87-8841-1805-f27ee46c4d47
Time2018-01-02 05:27:20Z
Things i have tried :
- This blog post - https://community.powerbi.com/t5/Service/Enterprise-gateway-quot-cannot-connect-to-the-mashup-data-s...
- Traffic is permitted on the company's firewall (VM where gateway is installed) for all the domains listed in https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem#portsarticle
Any help is highly appreciated. Thanks in advance.
Updating the gateway on the server it was setup on resolved the issue for me
11 Replies
Anonymous
What's your data source?
Please try to recreate your data source under "Manage Gateway", then edit the credential in Dataset setting before you excute a refresh. If it still doesn't work, please create a support ticket with Activity ID and Request ID provided.
Regards,
SQL server is my datasource.
I recreated the dataset and gave the credentials while creation of the data source so it doesn’t ask me edit the creds under dataset settings. Please refer the below screenshot for further clarification.
I am still getting the below error message.
Cannot connect to the mashup data source. See error details for more information.
Please try again later or contact support. If you contact support, please provide these details.Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID20eb6328-5c99-43c0-b3c1-c7a245427e76
Request ID18ae3a54-23d0-7e79-db04-a64af487ad44
Time2018-01-03 08:34:48Z
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 Anonymous
Did you resolve the issue?
I have the excat same problem
Updating the gateway on the server it was setup on resolved the issue for me
