Table is not visible in data source

[romals29]

Hi

I have added a new table in my local MySQL database but the new table is not available when I connect the same database in Power BI desktop.

How to sort out this issue.

May you please help me on this 

Thank you in advance

Romal

[v-henryk-mstf]

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.

[romals29]

Hi Henry

I am already connecting through power query desktop.

[lbendlin]

- clear Power BI cache

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

[romals29]

Hi lbendlin

I cleared cache in power bi desktop but still the table is not visible

[lbendlin]

Is there anything special about the new table? Binary or spatial Field types?

[romals29]

No its just a simple table just has one INT column and one VARCHAR column

[lbendlin]

Have you tried to specify the table name manually in Power Query as I had recommended?