cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sguenther Member
Member

Re: Enterprise gateway "cannot connect to the mashup data source"

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!

sguenther Member
Member

Re: Enterprise gateway "cannot connect to the mashup data source"

I opened a support issue on that one. Will let you know once resolved.

TH Frequent Visitor
Frequent Visitor

Re: Enterprise gateway "cannot connect to the mashup data source"

Did you solve the problem? Have the same problem at the moment:/

cfzini Frequent Visitor
Frequent Visitor

Re: Enterprise gateway "cannot connect to the mashup data source"

Hi everyone!

 

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:

ID da atividade74425664-f642-46e9-bae1-2d2bca184e06
Solicitar ID87e821a7-97be-0982-04c4-87ddeae0d457
ID de correlação6bb57f90-49b1-31c7-872d-4334e1c87e12
Capturar.PNG
 
 
 
 
 
 
 
 
 
 
I've already uninstalled my Personal Gateway to check if it would work, but no, it didn't changed much.
DanDeHaven Frequent Visitor
Frequent Visitor

Re: Enterprise gateway "cannot connect to the mashup data source"

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.

arthastic Frequent Visitor
Frequent Visitor

Re: Enterprise gateway "cannot connect to the mashup data source"

Hi guys!
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.

jcasado New Member
New Member

Re: Enterprise gateway "cannot connect to the mashup data source"

Did you finally have a solution for this issue? I have the same problem

ayushnigam268 Regular Visitor
Regular Visitor

Re: Enterprise gateway "cannot connect to the mashup data source"

Hi @dimazaid

The solution for this post didn't work for me. I only have personal gateway installed. Is there any work around?

Thank You

caslus Frequent Visitor
Frequent Visitor

Re: Enterprise gateway "cannot connect to the mashup data source"

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))
Versión:13.0.5314.162
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.
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:MySql
Microsoft.Data.Mashup.ValueError.DataSourcePath:http://orbisolar.com.mx;tickets
Microsoft.Data.Mashup.ValueError.ErrorCode:-2147467259
Microsoft.Data.Mashup.ValueError.Message:Unable to connect to any of the specified MySQL hosts.
Microsoft.Data.Mashup.ValueError.Reason:DataSource.Error
geet Frequent Visitor
Frequent Visitor

Re: Enterprise gateway "cannot connect to the mashup data source"

Hey,

 

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: geet.chawla@sainsburys.co.uk