MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server

Hi there

I encountered an error that looks more like a bug to me (hopefully I am worng).

when I try to select one column from existing query (Power Query) - receive an error. The error persists only for product related columns, other columns return no errors.

Context:

I have two flat MySQL dables (AWS RDS) that I query (6 queries in total). These 6 queries are then appended into one DATA query (table). Then I create separate dimensional tables like 'stores', 'consultants', 'products'.

'stores' and 'consultants' are created smothly, however for some reason I encounter an error with 'products' table.

I can still derive 'products' from original six queries, so there is a workaround, however would still want to understand what causing the issue.