Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
11 months ago
Solved

MySQL 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 i...
  • v-veshwara-msft's avatar
    v-veshwara-msft
    10 months ago

    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's avatar
Anonymous
Not applicable
11 months ago

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's avatar
Anonymous
Not applicable
11 months ago

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.