MySQL Scheduled Update

[Syndicate_Admin]

Hello everyone, very good day

I'm testing the remote connection from PowerBi to MySQL

I've already published the model, but I'm hesitant about the connections for scheduled updates,

I tried but it throws me the following error

Note that this, as I said, is remote, NOT LOCAL

if someone knows what the connection is like if another gateway is needed,

I already have models with SQL Server and I don't have any problem there

I remain attentive

Thanks a lot

[v-veshwara-msft]

Hi @Syndicate_Admin ,

Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.

Thank you.

[v-veshwara-msft · Accepted solution]

Hi @Syndicate_Admin ,

Thanks for posting in the Microsoft Fabric Community, and also thanks @FBergamaschi and @Anonymous  for the helpful inputs shared earlier.

To add a bit more clarity - the error “MySql.Data.MySqlClient not found” typically happens when the MySQL connector is missing on the machine where the gateway is installed. Power BI Desktop may work fine since the connector is installed locally, but for scheduled refresh in the Service, the gateway machine also needs that connector.

To fix this:

• Install the MySQL Connector/NET (or the recommended ODBC driver) on the gateway machine.

• Restart the gateway service once installed.

• In Power BI Service, re-map the dataset to the gateway under Gateway connections, then re-enter and validate the MySQL credentials.

You can continue using your existing gateway if it can access both SQL Server and MySQL. If it cannot reach MySQL, then a separate gateway on a machine with network visibility to the MySQL server would be required.

Similar thread: Solved: Error MySql.Data.MySqlClient - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.

Thank you.

[Anonymous]

Hi @Syndicate_Admin,

Thanks for reaching out to the Microsoft fabric community forum. The error shows Power BI cannot find the MySQL provider on the gateway (“MySql.Data.MySqlClient”), so your scheduled refresh cannot connect. You can re-use your existing gateway only if that gateway machine can reach the MySQL server on the network as mentioned by 

@FBergamaschi earlier. 

Just following up to your previous conversation, I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround so that other users can benefit as well.  And if you're still looking for guidance, feel free to give us an update, we’re here for you.

I would also take a moment to thank @FBergamaschi, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.

[Anonymous]

Hi @Syndicate_Admin,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround so that other users can benefit as well.  And if you're still looking for guidance, feel free to give us an update, we’re here for you.

Best Regards,

Hammad.

[FBergamaschi]

It seems the data source is inaccessible

Do you have a gateway that can reach this database?

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[Syndicate_Admin]

Hi @Syndicate_Admin @me I do have a gateway, but I use it for SQL Server which is also mounted on a server

Can you use the same? or should another one be generated?

[FBergamaschi]

If that gateway can reach the MySQL, use it

Otherwise you need to install a gateway on a machine that can see the MySQL database, and use an email of the domain of your tenant

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI