Unable to Connect to MySQL Database

[Anonymous]

Upon the recent update, I have been unable to connect to our MySQL data sources.  I have been receiving the following error message: "An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'"

Has anyone else encountered this error and were you able to find a solution? 

Thank you for any advice you may be able to offer that may help me resolve this issue. 

-Grant

[mnarmeen]

https://social.technet.microsoft.com/wiki/contents/articles/32004.power-bi-tips-for-working-with-mys...

[eparedez]

Using a power bi desktop or service?

Do the following:

- Check the properties connection..
- Check if the MySQL port is open

[Anonymous]

I am using Power BI Desktop.  

[Anonymous · Accepted solution]

Hi @Anonymous,

In your scenario, are you able to connect to the MySQL database in MySQL workbench? Please ensure that MySQL workbench is installed in the same machine as Power BI Desktop.

If the connection is successful in MySQL workbench, use same connection string and make sure that you use Database credential in Power BI Desktop to connect to the MySQL database, and you can review this blog about connecting to MySQL in Power BI Desktop.

Thanks,
Lydia Zhang

[Anonymous]

After clearing the previous permission and reconnecting to the database everything is working smoothly. 

Thank you for the solution!

[Anonymous]

Upon the recent update, I have been unable to connect to our MySQL data sources.  I have been receiving the following error message: "An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'"

Has anyone else encountered this error and were you able to find a solution? 

Thank you for any advice you may be able to offer that may help me resolve this issue. 

-Grant