Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
nanoterremoto
New Member

Flujo de datos con ODBC con SSL

Hola a todos,

 

Actualmente tengo un cuadro de mandos que obtiene la mayoría de los datos de una base de datos MySQL. Para realizar la conexión con Power BI Desktop he usado un conector ODBC junto con el driver de MySQL ya que la conexión con la base de datos requiere de unos certificados SSL para validar la conexión.


Con Power BI Destkop todo bien, el problema surje al publicar el cuadro de mandos. Ahora mismo estoy usando un gateway personal instalado en mi equipo y el CdM se actualiza perfectamente en la nube, pero quiero usar flujos de datos para hacer que las actualizaciones de datos sean incrementales.

 

Para ello me he instalado el gateway estándar, no el personal, lo he configurado con la cuenta correspondiente y demás.

 

El problema está al añadir los flujos de datos. Para ello selecciono ODBC como origen de datos pero solamente me da la opción de esto:

 

nanoterremoto_0-1704886603155.png

 

He usado esta configuración: 

 

nanoterremoto_1-1704886671864.png

Siendo esta la cadena de conexión completa: Driver={MySQL ODBC 8.1 Unicode Driver};Server=Helpdesk.befesa.com;puerto=3306;Database={otrs};

 

Al darle a siguiente obtengo este error:

 

Se ha producido una excepción: ODBC: ERROR [HY000] [MySQL][ODBC 8.1(w) Driver]Access denied for user 'befesa_ro'@'185.14.62.59' (using password: YES) ERROR [HY000] [MySQL][ODBC 8.1(w) Driver]Access denied for user 'befesa_ro'@'185.14.62.59' (using password: YES). (Id. de sesión: 777ebd0a-39d2-4da7-b5e2-16554e2c8298, Región: europe)

 

Seguramente porque falte indicar en algun apartado los certificados SSL que si tengo agregados en el Power BI Desktop.

 

¿Alguna idea de como solventar esto?

 

Gracias.

2 REPLIES 2
v-nuoc-msft
Community Support
Community Support

Hi @nanoterremoto 

 

I understand that you're having trouble trying to configure a data flow through a standard gateway. The error "Access denied for user" indicates an authentication issue.

 

Try the following steps:

 

Verify user credentials. Make sure that user 'befesa_ro' has the appropriate permissions in the MySQL database.

 

Configure SSL on the gateway. You need to make sure that the SSL certificate is installed and properly configured on the machine running the gateway.

 

The connection string you provided appears to be incomplete in terms of SSL configuration. You'll need to add the necessary parameters to specify the location of the SSL certificate. Such as:

 

Driver={MySQL ODBC 8.1 Unicode Driver};Server=Helpdesk.befesa.com;Port=3306;Database=otrs;sslca={path_to_ca_certificate};sslcert={path_to_cert_certificate};sslkey={path_to_key_certificate};

 

Replace {path_to_ca_certificate}, {path_to_cert_certificate}, and {path_to_key_certificate} with the actual file path of your certificate.

 

Once the connection string is updated, try to test the connection through the standard gateway again.

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @v-nuoc-msft 

 

First of all, thanks for you reply.

 

The user and password are correct because I use them in my computer and they work correctly, I have access to the database and I can work normally with Power BI Desktop, the problem is when I try to configure the ODBC connection in cloud, in the Power BI website, where I have published the pbix to share it with other people. 

 

I have also used the sslca, sslcert and sslkey using local paths, for example, c:\users\"user"\Desktop\file.pem for each value, should I use a local path or how should I use this parameters? I tried to upload the 3 certificates to sharepoint and use the sharepoint link as path but it didn´t work.

 

Thanks.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.