Forum Discussion

GalasVetal's avatar
GalasVetal
New Member
1 year ago

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 dat...
Need Help
GalasVetal's avatar
GalasVetal
New Member
1 year ago

tharunkumarRTK 

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

tharunkumarRTK's avatar
tharunkumarRTK
Super User
1 year ago

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's avatar
    GalasVetal
    New Member
    1 year ago

    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