pkromer
asked on
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?
--------------------------
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?
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
YOU DA MAN!!! Thanks much. It didn't like the hyphen.
ASKER
Thanks very much.
There could be a syntax error before this part of the SQL statement.