Geo map doesn't recognize latitude, longitude dimension
I tried building a sample report from nyc-tlc:yellow.trips in BQ.
First I got the following error when creating the connection: "You are setting dropof_longitude as a Latitude, Longitude, but we couldn't recognize its format. This may cause unexpected behavior. Would you like to continue?".
I did continue and the Geo map did not recognize latitude, longitude dimension.
What should be the data type for the Geo map to work?