BQ → Data Portal Updates

Simply configure it as described in the Data Portal Help to view the data in the BigQuery table on the Data Portal.

• https://support.google.com/datastudio/answer/6370296?hl=ja
• https://support.google.com/datastudio/answer/6295968?hl=ja

Data referenced by the Data Data Portal is cached.Please check the cache below.
https://support.google.com/datastudio/answer/7020039

I don't know exactly what the "real-time" requirement is, but you can manually update the report data (manual cache updates) on the data portal, so you can view the data in the current BigQuery table.