Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.