Connecting to Google Cloud SQL Field Name and Hebrew
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 ?