I am able to connect to Mysql via ODBC and all of a sudden now I am unable to fetch data from tables (I can see tables).
Later I installed new connector from the link provided in Microsoft Power BI documents
Now I am unable to connect through native connection as well
I have enabled database credentials in the below settings.
file- options and settings- data source settings
Make sure you've started the MySQL service.
I have started MySQL services. But, whenever I try to connect to MySQL server then automatically services are stopped.
Hence, I need to start manually(i.e in service.msc).
Then Whenever I try to connect then it is the same issue (MySQL services will go down in server).
This might be more related to MySQL.