Data Studio
4.9K members online now
4.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Issue with exclusion filter and MySql connection

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi all,

 

I have connected a mySql db to DataStudio as a backup for my main db on bigquery.

I need to retrieve a smaller set of data using a exclude filter. On my bigquery connection it's all working fine while on mySql it doesn't work properly : if I set a condition that it's not "Equal to (=)" I get an "Configuration error - There`s a query error". 

If, on the other hand, I set the include condition it works correctly (also with a condition that it's not "Equal to (=)" )

ex: 

 Screen Shot 2017-05-03 at 12.23.28.png

Screen Shot 2017-05-03 at 12.29.53.pngWorking one with include:

Screen Shot 2017-05-03 at 12.38.38.png

Working one with exclude:

Screen Shot 2017-05-03 at 12.29.53.png

 

Any ideas ? 

 

Thanks

 

Issue with exclusion filter and MySql connection

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Still no ideas ? Could it be a bug ?

 

Thanks

Issue with exclusion filter and MySql connection

Explorer ✭ ✭ ☆
# 3
Explorer ✭ ✭ ☆

Maybe i ask a stupid question, but your field "DESC_STATO" have the exact value "INTERROTTA" ?