Forum Discussion
error when updating data from MySQL
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.'
5 Replies
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!
tharunkumarRTK
Power BI Desktop everything works correctly.
And app.powerbi.com gives an error when connected to MySQLI 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!
Hi GalasVetal ,
Please refer this article -
https://scalegrid.io/blog/connect-mysql-to-power-bi/
I hope it will be helpful.
Thanks,
Sai Teja
