Link to home
Start Free TrialLog in
Avatar of pkromer
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?
Avatar of Francisco Igor
Francisco Igor
Flag of Canada image

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.
Avatar of pkromer
pkromer

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
Avatar of Francisco Igor
Francisco Igor
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pkromer

ASKER

YOU DA MAN!!! Thanks much. It didn't like the hyphen.
Avatar of pkromer

ASKER

Thanks very much.