Error when connecting to MySQL tables: The column 'ID' of the table was not found

[LuxsBV]

When I try to connect to one of my tables in PowerBI desktop in a new project without any current tables, I receive the error message: The column 'ID' of the table was not found. This error does not seem to appear at every table in my MySQL database. The table does have an ID column, which is also characterised as the PK in the table.

This is the first time that I am trying to load the table.

Many thanks in advance!

[Eric_Zhang]

@LuxsBV

Can you be more specific on how to load the data from MySQL? Do you import data from the table or through a query? If through a query, what is the query like?

[LuxsBV]

@Eric_Zhang @arify

I am loading the data via PowerBI desktop and 'Get data' > Mysql. I connect to the server and the tables are loaded. However, when I select some tables it gives the abovementioned error message (I think I import it directly from the table using the PowerBI interface). The strange thing is, that some tables are imported correctly without any problems.

[Eric_Zhang]

@LuxsBV

What the MySQL version? Would you mind posting the table creating DDL so that I can try to reproduce the problem.

[arify]

That looks very odd. Can you tell me how you created the table so we can try to reproduce the error locally? And, to make sure, you haven't done any operations after loading the column?

Thanks