I'm still faced with this issue. It started by installing the new gateway.
I then uninstalled the old personal gateway as well as the enterprise gateway that were installed on the same machine. The issue however still persists. I would like to roll back the installations, but I can't find the old personal gateway installer anywhere.
This is breaking the entire BI infrastructure in my company. Please, fix is needed urgently!
I'm facing a similar problem.
I'm conected with an SAP Bussiness Warehouse Server, in which the data is stored in Cubes (MDX).
After publishing my report, I had to stablish an On-Premisse Gateway, which after some headaches was conected
Now, when I try to mix the dimensions and measures from the cube, it gives me the same message: "cannot connect to the mashup data source".
This is a part of the message:
Having this issue with an Enterprise Gateway. I removed a Personal Gateway (that had worked fine). The data sources in the Enterprise Gateway all connect without error yet the Datasets won't manually refresh or schedule refresh. Reports don't refresh either. I have to refresh everything from Desktop manually.
It's a definite show-stopper.
Any help from the technical team on this would much appreciated.
I've found the solution for me.
I noticed that this problem appeared after adding the new server in our domain.
So I decided to use "gpupdate /force" from the cmd on the machine where DataGateway installed.
After group policy were updated the problem disappeared.
I believe I had the same problem
No se puede conectarHemos detectado un error al intentar conectar con http://orbisolar.com.mx. Detalles: "No se pudo registrar este origen de datos para ninguna instancia de puerta de enlace en este clúster. A continuación encontrará más información sobre los errores específicos de cada instancia de puerta de enlace."Ocultar detalles
|Identificador de actividad:||2b175acd-e92c-a3ff-488d-6ba8438edfeb|
|Identificador de la solicitud:||ef5bdac6-e4db-689d-453a-7dc16c13b7c1|
|URI de clúster:||https://wabi-south-central-us-redirect.analysis.windows.net|
|Código de estado:||400|
|Código de error:||DMTS_PublishDatasourceToClusterErrorCode|
|Hora:||Tue May 22 2018 18:17:48 GMT-0600 (Hora verano, Montañas (México))|
|bi:||No se puede conectar con el origen de datos del mashup. Para obtener más información, consulte los detalles del error.|
|Código de error subyacente:||-2147467259|
|Mensaje de error subyacente:||MySQL: Unable to connect to any of the specified MySQL hosts.|
|Microsoft.Data.Mashup.ValueError.Message:||Unable to connect to any of the specified MySQL hosts.|
I am facing a similar issue sinct the past 3-4 weeks. I tried reaching to power BI Help services but the issue is still not resolved. Can you please help.
Email Ref: email@example.com