Forum Discussion
AdministratorMySQL Scheduled Update
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
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.
-
7 Replies
- FBergamaschi
Super User
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_AdminHi @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
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.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.
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.
-
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.
