Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
Hi @Anonymous ,
From the error, it seem that there should be some syntax error for your SQL Query. Please recheck the query which the error message mentioned.
In addition, could you run the query successfully in My SQL?
Best Regards,
Cherry
Hi @Anonymous ,
From the error, it seem that there should be some syntax error for your SQL Query. Please recheck the query which the error message mentioned.
In addition, could you run the query successfully in My SQL?
Best Regards,
Cherry