Forum Discussion

fmendoza's avatar
fmendoza
Regular Visitor
6 years ago
Solved

Automatic update problem with MYSQL data source

Hello dears!. I would like you to support me with an inconvenience, when programming the automatic update of a dashboard which connects to a MYSQL database this shows the following error. Faile...
Dataflow
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

fmendoza's avatar
fmendoza
Regular Visitor
6 years ago
 

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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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