Time Zone in Data Studio Reports

I have a same situation as we use Big Query, but our time zone is GMT+7. We have to manually add more 7 hours to all date_time value. Is there any better way to treat the UTC Date Time to be display in our timezone? The date filter should work with the local timezone too.

Then in BigQuery, all our date/time fields were timestamps, so we convert them to DATETIMES at our timezone, e.g.

DATETIME(createdAt, 'Europe/London')

And it will handle all of the time zone stuff like daylight savings.

This worked for us as we are doing other data processing that requires a view anyway, but you do lose the ability for Data Studio to restrict query size based on date partition when using one (see my issue tracker issue https://issuetracker.google.com/issues/63319132)