Table is not visible in data source

Community Support

4 years ago

Which way are you connecting to the mysql data source? For powerbi, the best way is Connect to MySQL database from Power Query Desktop.

take the following steps:

Select the MySQL database option in the connector selection.
In the MySQL database dialog, provide the name of the server and database.
Select the Database authentication type and input your MySQL credentials in the User name and Password boxes.
Select the level to apply your credentials to.
Once you're done, select OK.
In Navigator, select the data you require, then either load or transform the data.

For more details, you can read related document as below:

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

Forum Discussion