Forum Discussion
Automatic update problem with MYSQL data source
Hi fmendoza ,
If this connector works well on the desktop side, I think ti should more relate to compatibly between the gateway and MySQL drever client versions.
Have you tested to use other connectors to get data from MySQL? (e.g. ODBC) They are more stable and compatible with most of the gateway client versions.In addition, you can also open a support ticket to get further support from power bi team.
submit a support ticket
Regards,
Xiaoxin Sheng
Hi fmendoza,
What version of connector did you use? Have you used the same bit of client and data source? (according to the error message, it seems like power bi can't recognize the Datasource due to different client bit/versions)
Please share more detail information to help us clarify your scenario.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
I was previously using the personal mode version and I always had the same problem. As a possible solution, install the other version without having a result.
As an additional test, I made a dashboard with connection to another MYSQL base and the problem persisted. Make a dashboard with connection to a Postgresql database and this does not present any inconvenience.
Hi fmendoza ,
If this connector works well on the desktop side, I think ti should more relate to compatibly between the gateway and MySQL drever client versions.
Have you tested to use other connectors to get data from MySQL? (e.g. ODBC) They are more stable and compatible with most of the gateway client versions.In addition, you can also open a support ticket to get further support from power bi team.
submit a support ticket
Regards,
Xiaoxin Sheng