Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Using a power bi desktop or service?
Do the following:
- Check the properties connection..
- Check if the MySQL port is open
I am using Power BI Desktop.
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
After clearing the previous permission and reconnecting to the database everything is working smoothly.
Thank you for the solution!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.