Issue with Country Type Field Automatically Mapping to target_country_region in Looker Studio

[yukichikawa]

I added a BigQuery table as a data source, and a certain field within the table was automatically defined as a Country type. I created a report in September 2023 to display this field, and until now, the data as stored in BigQuery was being displayed. However, starting from a day in May 2024, it began converting to the "target_country_region" field from the "bigquery-public-data.google_ads_geo_mapping_us.ads_geo_country_mapping" table.

In another BigQuery table, there is similar data of the Country type, but it continues to display the data as stored in BigQuery without mapping to "target_country_region".

I have decided to stop using the Country type and redefine the field type as Text in Looker studion.
Is this a bug in Looker studio or BigQuery ?

[AlexeyKlishin]

Do you know how your field was definted? To map country correctly you should be able to use the formula TOCOUNTRY(country, "COUNTRY_ISO_CODE"), country is the code. That way it will convert to user-friendly value using the table above