How to get real time reports in Data Studio[ Edited ]
How to get real time reports in Data Studio
Very clever solution.
One thing to point out, however, is that even for Sheets data sources, the cache will expire in 12 hours so any new queries issued by the report will pull in fresh data after that. (Obviously, that doesn't help your real time dashboard use case, but wanted to point it out).