AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
2.8K members online now
2.8K 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" ?