Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

[drking]

I am trying to add an Excel file to my gateway on my Power BI Service.

Unfortunately I receive the following errorcode: DMTS_PublishDatasourceToClusterErrorCode.

This error code is not described on the troubleshootingpage being:

https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-tshoot/.

Can someone help me?

Many many thanks. DrKing.

[max-jong]

I have the same issue but I installed gateway (Personal). I noticed once you have a file type(Excel) data source, you will need to use the Gateway personal instead of the standard gateway, I don know why, but for now it is an alternative resolution for me.

[joa_code]

El error DMTS_PublishDatasourceToClusterErrorCode hace referencia a tener un problema con el origen de los datos. grabar que cuando el gatwaye se esta ejecutando todo su acceso esta delimitado por el acceso que tiene la maquina misma en la red.

se soluciona buscando el parche correcto encontrando el archivo que quieres cargar.
Un problema habitual es crear el archivo pbix. en una computadora y tener en ella el archivo de Excel luego tendras que mover todo a tu servidor de PBI con el gateway.

El problema me apareció por primera vez tratando de conectar archivos a una carpeta en dropbox mi pc no se llamava igual que el servidor y el parche estaba mal ingestado en el pbix.

ahora trato de escalar en la red. esto quiere decir que las credenciales que coloco en mi puerta de enlace tienen acceso a un archivo que se encuentra en una pc diferente pero el parche tiene la dirección de sus compartidos. el parche correctamente lo abre el buscador de archivos pero no el gateway de power bi. ayuda.

[Anonymous]

Hi all,

i've also the same problem with gateway.
I'm studing for getting the PBI certification (exam 70-778) and i'm currently studing the chapter about on premises data connection.
I followed all the passages of the book and found that error when trying to connect to the on premise data source:

La connessione non è riuscita: Si è verificato un errore durante il tentativo di connessione a . Dettagli: "Non è stato possibile registrare questa origine dati per alcuna istanza del gateway in questo cluster. Vedere sotto per maggiori dettagli sugli errori specifici relativi alle singole istanze del gateway."Nascondi dettagli

ID attività:	515aeb12-d483-4ead-98ad-272428a17d87
ID richiesta:	b8df4445-40f1-153f-0d3b-5003402ab703
URI cluster:	https://wabi-europe-north-b-redirect.analysis.windows.net
Codice di stato:	400
Codice errore:	DMTS_PublishDatasourceToClusterErrorCode
Ora:	Wed Oct 02 2019 10:57:48 GMT+0200 (Ora legale dell’Europa centrale)
Versione del servizio:	13.0.10882.187
Versione client:	1909.4.014

GatewayProva:

L'account del servizio del gateway dati locale non è riuscito a rappresentare l'utente.

Risoluzione dei problemi di connessione

I cannot found appropriate support in any site.
If those are the premises to study for an exam based on a defective product, i cannot imagine how fair the exam could be.

Thank you in advance for the support,
kind regards
Pietro Negri

[Anonymous]

Não é possível conectar: Encontramos um erro ao tentar conectar a . Detalhes: "Não foi possível registrar essa fonte de dados para nenhuma instância de gateway nesse cluster. Veja mais detalhes abaixo sobre erros específicos para cada instância de gateway."Ocultar detalhes
ID da atividade: 63b33c00-0063-43cf-bc92-34f7e722422b
Solicitar ID: 758d535c-2cf6-e802-e6d7-d5c8415e394d
Cluster URI: https://wabi-brazil-south-b-primary-redirect.analysis.windows.net/
Código de status: 400
Código de Erro: DMTS_PublishDatasourceToClusterErrorCode
Hora: Thu Apr 09 2020 14:51:28 GMT-0300 (Horário Padrão de Brasília)
Versão do serviço: 13.0.12739.219
Versão do Cliente: 2003.3.022
GatewayDivitech: A conta de serviço do gateway de dados local não pôde representar o usuário.

Tamém estou com esse erro e não consigo indentificar como resolvelo. Pois não encontro nenhum documento atualizado sobre esse erro.

[Kamakshi]

Hi ,

We also face the same issue, do we have a solution for this ?

Could you please help us if any.

Thanks

Kamakshi 

[Gabrielhennig]

Olá Kamakshi,

Quando tive problemas de conexão com o gateway dependi de atualização da versão do gateway. Mas pode relatar o erro que está tendo?

[Kamakshi]

Hi Gabrielhennig,

Thanks for the response. I have the same error as above.

Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

Thanks

Kamakshi 

[--staudi--]

Hi all!

I have the same issue when trying to add a gateway.

Had the issue with ODBC - corrupt memory -but seems to be fixed now with the dec update - thanks for that

But now i am not able to get my odbc connection work.

Any ideas so far?

Thanks in advance

Staudi

Statuscode:	400
Fehlercode:	DMTS_PublishDatasourceToClusterErrorCode
Zeit:	Tue Dec 12 2017 08:48:47 GMT+0100 (Mitteleuropäische Zeit)
Version:	13.0.3419.168

[Anonymous]

I get the same error also with an ODBC connection. I think it is Gateway software version related and that there may be an issue with the most current build. I have another gateway with the same connection on a different pc (but an earlier build), and there is no problem. Hoefully they'll fix this soon!

[arthurcruz]

We are having the same issue here.

I have just updated my On-premises Gateway on our server and this error started occuring.

Have you guys opened a ticket somewhere?

[Gabrielhennig]

Olá @arthurcruz,

Atualizei a versão do gateway ontem e já está funcionando normalmente.

Att;

Gabriel 

[NeetBI]

Hello,

I'm having the same issue with a configuring a gateway on PBI. The gateway is created, but can't connect (always considered as Offline) even if I use the app.powerbi view.
I'm using a Personal Gateway and already try HTTPS mode.

This my error log, as you can see everything has processed correctly except the transfert service which is disconnected

DM.PersonalGateway Information: 0 : 2017-12-20T12:39:29.2983537Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 563D2EDA [DM.PersonalGateway] Starting gateway process
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:29.4977496Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 D1BCCC47 [DM.GatewayCore] Setting thread pool worker threads = 300, min completion port threads = 300
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:29.4977496Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 F1E4EEC3 [DataMovement.PipeLine.MashupCommon] Mashup extension file Impala exists. Start loading.
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.0799244Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 C2DDEB76 [DataMovement.PipeLine.MashupCommon] Loading mashup extension file Impala succeeded.
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.0799244Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 0A02C197 [DataMovement.PipeLine.MashupCommon] Mashup extension file Snowflake exists. Start loading.
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.0955524Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 3B3113B6 [DataMovement.PipeLine.MashupCommon] Loading mashup extension file Snowflake succeeded.
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.0955524Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 E9CC64C1 [DataMovement.PipeLine.MashupCommon] Mashup extension file R exists. Start loading.
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.1131865Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 A6098318 [DataMovement.PipeLine.MashupCommon] Loading mashup extension file R succeeded.
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.1131865Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 3B1E0DB8 [DataMovement.PipeLine.MashupCommon] Mashup extension file Netezza exists. Start loading.
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.1182000Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 0BDBD689 [DataMovement.PipeLine.MashupCommon] Loading mashup extension file Netezza succeeded.
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.1182000Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 417A821E [DM.GatewayCore] Starting test connection pool if necessary.
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.1338291Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 6A83A143 [DataMovement.PipeLine.MashupCommon] Mashup Container Pool TestConnectionPool created.
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.1338291Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 9AE73F5E [DM.GatewayCore] Test connection pool created True.
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.1494556Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 215E5C18 [DataMovement.PipeLine.MashupCommon] Mashup Test Connection Settings - TestConnectionTimeout: 00:00:50.
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.1494556Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 EAD96F9C [DataMovement.PipeLine.MashupCommon] Mashup Engine Container Settings - ContainerMaxCount: 6. ContainerMaxWorkingSet: 256MB. ContainerTimeToLive:
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.1494556Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 06EC9A10 [DM.GatewayCore] New runner was explicitly started on the 'Configuration service' controller
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.1650826Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 5FBD3146 [DM.GatewayCore] Attempting to create and start service host for 'Configuration service'
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.1807091Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 79BDE466 [DM.GatewayCore] Configuration service started
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.1807091Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 8F619B72 [DM.GatewayCore] Successfully created and started service host for 'Configuration service'
DM.PersonalGateway Information: 0 : 2017-12-20T12:39:30.2124662Z DM.PersonalGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 748E952D [DM.GatewayCore] Not starting transfer service because the gateway is disconnected

Any update on this issue ?

[Anonymous]

i there.... I get the same error with an ODBC connection. I have several gateways loaded on my service, and one has been setup with the same ODBC connection (on a different PC) and that works fine... I think this is an issue with the current build of the Gateway software installed on the source computer (the one workign in my case is an older build). Hopefully the issue will be resolved soon!

[Gabrielhennig]

Olá Staudi e aos demais, 

Também continuo com o problema no gateway, a conexão do power bi desktop parece estar corrigida, porém o "DMTS_PublishDatasourceToClusterErrorCode" na configuração da fonte de dados ainda continua, tanto no banco Firebird como no Postgres.

Alguma posição quanto a essa inconsistência? Obrigado.

Gabriel Hennig

[drking]

In reply to the message below. The issue is still not resolved. Many thanks for asking.

Kind regards.

DrKing

Van: Power BI Community Administrator [mailto:mailer@lithium.com]
Verzonden: dinsdag 21 november 2017 07:54
Aan:

Onderwerp: Did you get the answer you needed?

Hello drking,

Your topic recently received replies.

Topic: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode
Date: 11-15-2017 05:22 PM

Did it solve your problem?

Click here to view the replies and mark one as an Accepted Solution.

This helps others find helpful answers in the community too!

Thanks for being a Microsoft Power BI Community member.

Your Microsoft Power BI Community Team

Microsoft Power BI Community sent this message to bomaye@planet.nl.

Don't want to receive emails from us? Just click here.

[v-huizhn-msft]

Hi @drking,

You create a support ticket and get dedicated reply? If it is, please wait for update.

Best Regards,
Angelia

[drking]

@ Angelina,

Thanks for your reply.

I logged in at my PowerBI Service and selected Gateway maintenance. All of a sudden I have a new error message from my gateway, that I did not have two days ago. The message is as follows:

The gateway is ofline or unreachable. Hide details

Activity-ID:                              e18858e5-d777-4bed-b7b5-2d37daf73596

Request-ID:             3155b090-0e0d-0034-9d7b-77f646f38012

URI cluster:              https://wabi-europe-north-b-redirect.analysis.windows.net

Statuscode:             400

Errorcodecode:        DM_GWPipeline_Client_GatewayUnreachable

Time:                       Fri Nov 17 2017 17:27:26 GMT+0100

Version:                   13.0.3154.166

Is this perhaps a major breakdown of a server?

The details of the message of two days ago are:

Kan niet verbinden: Er is een fout opgetreden tijdens de verbindingspoging met D:\data\OneDrive – <User>\2000860520100_PowerBi_ontbreken_verbandcontrole\2000860520100_DbKleur.xlsx. Details: Details verbergen

Activity-ID:                              96bc52f1-10af-5939-11e0-384e793e0ae4

Request ID:              0bbe0641-9d01-7602-2ec9-f2272c9c55c2

URI cluster:              https://wabi-europe-north-b-redirect.analysis.windows.net

Statuscode:             400

Foutcode:                 DMTS_PublishDatasourceToClusterErrorCode

Tijd:                         Wed Nov 15 2017 17:02:15 GMT+0100

Versie:                     13.0.3154.166

<User>:                    Received error payload from gateway service with ID 322614: Mashup expression evaluation error. Reason: ..

[JasonC]

I'm getting the DMTS_PublishDatasourceToClusterErrorCode error too.  We just installed the gateway today.  I'm able to connect to "web" data without issue.  But if I try to connect to an xls, xlsx, or csv I get the error below.  I read a semi-related post somewhere that pointed me towards.. 

https://docs.microsoft.com/en-us/power-bi/desktop-data-source-prerequisites

I installed the 64 bit version of the Access driver.  I didn't think this would fix the problem since i'm having the same issue regardless of the format (xls, xlsx, csv)....it didn't have any effect.

Other than that I'm really out of ideas of what to try since this conversation is the only mention of DMTS_PublishDatasourceToClusterErrorCode that google was able to find.

Unable to connect: We encountered an error while trying to connect to C:\Users\<userid>\Power BI\Data\TempoTime.csv. Details: ""Hide details

Activity ID:	07bc2ab2-7b0d-0fcf-7bfe-9c9f6c933139
Request ID:	dbaab779-bd86-27fd-a716-2277929e3d2d
Cluster URI:	https://wabi-west-us-redirect.analysis.windows.net
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Fri Nov 17 2017 12:30:07 GMT-0600 (Central Standard Time)
Version:	13.0.3074.197

HBC-Gateway:

Received error payload from gateway service with ID 607857: Missing or invalid credentials for data source. Reason = 'AccessUnauthorized', DataSource = 'Folder/c:\users\<userid>\power bi\data\tempotime.csv', DataSourceReference = '', DataSourceOrigin = '', DataSourceReferenceOrigin = ''..

-------------------------------------------------------------

Edit - I fixed it, but I can't say I like the fix.

1.  The file must be on the gateway server.  Mapped drives or UNC paths don't work.

2.  I must run Power BI desktop from the gateway server.  The file path in the query must match the file path in the Gateway/data source settings.

[BrunieToons]

This worked for me. The Gateway couldn't find the file when it was on our network or on my OneDrive (which mapped from the Gateway server's C: drive). When I created a new folder on the machine where the Gateway is running and pointed to that, it worked.

[v-huizhn-msft]

Hi @drking,

In the gateway datasource, you add one excel file or multiple files? In the excel filter, if there is any other third-part datasource connection? What's your detailed error message? Please share more information for further analysis.

Best Regards,

Angelia