cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
drking
Frequent Visitor

Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

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.

22 REPLIES 22
max-jong
New Member

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
Regular Visitor

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
Not applicable

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.
Anonymous
Not applicable

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
New Member

Hi ,

 

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

Could you please help us if any.

 

Thanks

Kamakshi 

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?

Hi Gabrielhennig,

 

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

Gateway Errorcode; DMTS_PublishDatasourceToClusterErrorCode

 

Thanks

Kamakshi 

--staudi--
New Member

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
Not applicable

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!

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?

Olá @arthurcruz,

 

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

 

Att;

Gabriel 

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
Not applicable

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!

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
Frequent Visitor

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.

Hi @drking,

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

Best Regards,
Angelia

drking
Frequent Visitor

@ 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
Regular Visitor

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.

 

 

 

 

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
Microsoft
Microsoft

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

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors