Table is not visible in data source

- clear Power BI cache

- specify another table first and then modify the Power Query code to your tabe

 

Hi romals29 ,

 

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:

Power Query MySQL database connector - Power Query | Microsoft Docs

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.