error when updating data from MySQL

[GalasVetal]

Hi

when trying to update data from the MySQL database in power bi service, it gives an error. Although Power BI Desktop connects correctly and the data is updated.
The hosting support where the database is located said that SSL is configured.

Maybe someone has encountered such a problem and knows a solution?

An error happened while reading data from the provider: 'A call to SSPI failed, see inner exception.'

[SaiTejaTalasila]

Hi @GalasVetal ,

Please refer this article -

https://scalegrid.io/blog/connect-mysql-to-power-bi/

I hope it will be helpful.

Thanks,

Sai Teja 

[tharunkumarRTK]

@GalasVetal 

MySQL database requires an on-prem data gateway connection, have you configured the gateway and mapped your semantic model to the gateway?

Please check if you would have followed all the steps mentioned here:

https://learn.microsoft.com/en-us/power-query/connectors/mysql-database

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[GalasVetal]

@tharunkumarRTK 

Power BI Desktop everything works correctly.
And app.powerbi.com gives an error when connected to MySQL

[tharunkumarRTK]

I understand. From Power BI service, you would need a gateway connection for the semantic model to refresh. 

Assuming you have a gateway server configured: (https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install)

If not already then

Install MySQL driver in your gateway machine

Configure the gateway connection in power bi service 

map your semantic model with the gateway connection 

then you would be able to refresh your model

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[GalasVetal]

@tharunkumarRTK 

I don't fully understand your recommendation to Install an on-premises data gateway.

Maybe because I forgot to specify that the MySQL database is on remote hosting that I rent and I don't have access to the settings.
At first there was a problem with no SSL, but the hosting owner set up SSL, but a new problem appeared.

As far as I understand, these are some problems with the SSL configuration on the server I am connecting to. Although I could be wrong