Google Data Studio, MySQL data source, fail

I set up a MySQL data source but cannot get it to work when creating a report. I add a field and immediately get a "configuration error", under which says:
----------------------------
Error Details

The query returned an error.

Error with SQL statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-Orders AS t0 GROUP BY Zip ORDER BY qt_Mbaw4iVj DESC' at line 1
Error ID: 37bfb97a
----------------------------
Anybody out there know how to get a MySQL data source working with a Google Data Studio report?
pkromerAsked:
Who is Participating?
 
F IgorConnect With a Mentor DeveloperCommented:
Do you have pointed a table with a name ended with  "orders" maybe you are using the wrong separator for table name (example: purchase-orders instead of purchase_orders)
0
 
F IgorDeveloperCommented:
Can you post the full SQL statement or the section near  
-Orders AS t0 GROUP BY Zip
.
There could be a syntax error before this part of the SQL statement.
0
 
pkromerAuthor Commented:
I don't have any SQL statement, all I'm doing is trying to add data to the report in GUI view. Whatever SQL statement is in that error was generated by Data Studio, not me directly.
0
 
pkromerAuthor Commented:
YOU DA MAN!!! Thanks much. It didn't like the hyphen.
1
 
pkromerAuthor Commented:
Thanks very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.