We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.

[KenWong]

Hi,

I am not able to refresh my data in Power BI.

The connector version I am using are;

But no matter how i try to repair the connector or reinstall them, same error message appears;

**Update*
This error only happen for existing dashboard, if I try to connect to the database using a new pbix, it works normally.

Thank you.

[Ritaf1983]

Hi @KenWong 

Please refer to the linked blog post and discussions about the same issue:

https://medium.com/riccardo-perico/power-bi-and-mysql-driver-v8-0-29-b269477dd68d

https://community.fabric.microsoft.com/t5/Desktop/We-were-unable-to-find-a-database-provider-with-in...

https://community.fabric.microsoft.com/t5/Power-Query/Power-BI-Desktop-Unable-to-Connect/td-p/8606

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[KenWong]

Hi Rita,

Thanks for the reply, but unfortunately these are the steps i had followed but the error persists.