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.9K members online now
2.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Connecting to Google Cloud SQL Field Name and Hebrew

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello

I have a lot of data to analyze so i uploaded the data to Mysql on google cloud platform

 

1. I added all google IP's to the "allow access" list

2. I find out that the column names must be without spaces

"Part Family" doesn't work well with formulas

"PartFamily" work's well

I hope someone will check and fix it

 

3. I have a problem with the "Filter Control"

my data is in Hebrew

If i add a filter control and define the data range dimension as a field with hebrew content

and define the filter as a page level filter

 

when my data resource is google sheet it works well and all other controls are filtered according to the filter control.

when my data resource is Mysql on GCP it dosen't works well and all other controls are showing no data.

 

Is it a problem with the Mysql or the Filter control on the data studio ?

 

Thanks

Shmuel

 

 

 

 

Connecting to Google Cloud SQL Field Name and Hebrew

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

 

 

MySql database is disined as

Character Set utf8

Collation utf8_general_ci

I changed the table Collation to utf8_general_ci

and it didn't help

 

 

The database
CHARACTER SET utf8 COLLATE utf8_general_ci