ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] - Gateway

[adrianohg]

Hi,

I use PowerBI Desktop to connect on my database MySQL with drive ODBC, that´s ok.

When configure gateway to connect the data set, I have this error:

Falha na última atualização: Wed Sep 23 2020 11:04:06 GMT-0300 (Horário Padrão de Brasília)
Erro durante o processamento de dados no conjunto de dados.Ocultar detalhes
Erro de fonte de dados: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dsn=wamp.codesa.local"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: rel_categoria_cat_consad.
Cluster URI: WABI-BRAZIL-SOUTH-redirect.analysis.windows.net
ID da atividade: 38440beb-fc88-4d32-bafc-2f67477b3910
Solicitar ID: b15e377b-c0a2-f2a4-a838-49f6d84b2395
Hora: 2020-09-23 14:04:06Z

Nome da Fonte de Dados/name: odbc_wamp
This is my gateway configuration:

Tipo da Fonte de Dados/type: ODBC
Cadeia de conexão/connection: dsn=wamp.codesa.local

Método de Autenticação/authentication: basic

Att,

Adriano Hantequeste Gomes

CODESA/CODFOR

[GilbertQ]

Hi there

Can you confirm you have installed and configured the 64bit version of the ODBC driver on your Gateway server?

[adrianohg]

Hi,

Yes, a use my desktop with gateway and my odbc drive is 64bits.

I try manual configure my gateway with this dataset:

Driver={MySQL ODBC 8.0 Unicode Driver};Server=wamp.codesa.local;Database=codforv2

It's woks, but i can't liking this gateway with my project. The only gateway display is dataset dsn=wamp.codesa.local

Att,

Adriano

[GilbertQ]

This is how I have got my ODBC Driver set up

"driver=Simba Athena ODBC Driver;dsn=Simba Athena; data source=AwsDataCatalog"

[adrianohg]

Hi,

This is my ODBC drivers list:

This is detail of my connection, test ok!

This is my project on PowerBI:

This is gateway configuration in the project:

This is my list of clusters gateways. The "odbc_wamp" connection unsuccessful

I create this cluster gateway, with successful connection. But i can't associate this cluster with my project, because only accept the datacluster with "dsn=wamp.codesa.local" the same off my PowerBI project.

Att,

Adriano Hantequeste Gomes

[GilbertQ]

Ahh can you make sure that all the Gateway servers have got the ODBC driver installed and configured.

[adrianohg]

The gateway server is my personal computer. The same computer use the PowerBI Desktop.

[v-kelly-msft]

Hi  @adrianohg ,

Check the similar thread below:

https://community.powerbi.com/t5/Power-Query/Add-odbc-data-source-to-On-Premises-Gateway-throws-IM00...

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[adrianohg · Accepted solution]

Hi,

I found solution.

I change gateway from my pesonal computer to my server (mysql) and configure the odbc on this server on System DNS.