topic Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode in Service

Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

drking — Wed, 15 Nov 2017 16:22:04 GMT

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.

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

talihubner — Thu, 16 Nov 2017 18:53:47 GMT

Hi, I'm getting the same error, but with an Oracle connection.

Did you solve your problem?

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

v-huizhn-msft — Fri, 17 Nov 2017 01:35:36 GMT

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

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

jrroby — Fri, 17 Nov 2017 15:03:05 GMT

You need to make sure you install the MySQL connector as identified on the follow prerequisites documentation: https://docs.microsoft.com/en-us/power-bi/desktop-data-source-prerequisites

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

drking — Fri, 17 Nov 2017 16:47:57 GMT

@ 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: ..

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

JasonC — Fri, 17 Nov 2017 22:50:34 GMT

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.

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

drking — Wed, 22 Nov 2017 13:33:02 GMT

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.

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

v-huizhn-msft — Thu, 23 Nov 2017 09:09:22 GMT

Hi drking,

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

Best Regards,
Angelia

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

--staudi-- — Tue, 12 Dec 2017 08:12:05 GMT

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

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

Gabrielhennig — Tue, 12 Dec 2017 11:40:44 GMT

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

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

Anonymous — Fri, 15 Dec 2017 09:25:33 GMT

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!

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

Anonymous — Fri, 15 Dec 2017 09:33:48 GMT

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!

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

arthurcruz — Sun, 17 Dec 2017 01:16:18 GMT

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?

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

NeetBI — Fri, 22 Dec 2017 10:03:58 GMT

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 ?

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

Gabrielhennig — Fri, 22 Dec 2017 10:36:28 GMT

Olá arthurcruz,

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

Att;

Gabriel

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

Kamakshi — Thu, 31 May 2018 05:05:42 GMT

Hi ,

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

Could you please help us if any.

Thanks

Kamakshi

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

Gabrielhennig — Thu, 31 May 2018 13:15:26 GMT

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?

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

Kamakshi — Thu, 31 May 2018 13:19:41 GMT

Hi Gabrielhennig,

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

Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

Thanks

Kamakshi

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

Anonymous — Wed, 02 Oct 2019 09:08:53 GMT

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

Re: Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

Anonymous — Thu, 09 Apr 2020 17:55:04 GMT

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.