使用Google Apps脚本在Google Data Studio上自动刷新 [英] Auto Refresh on Google Data Studio using Google Apps Script

问题描述

我已经将Data Studio报表连接到我们的内部SQL数据源，并且我一直在寻找一种以一定间隔自动刷新报表的方法.

I have connected a Data Studio report to our internal SQL data source and I've been searching for a way to auto refresh the report at certain intervals.

到目前为止，我唯一发现的是名为Data Studio Auto Refresh的插件，该插件无法正常工作.

The only thing I found so far is the plugin called Data Studio Auto Refresh, which is not working.

是否可以使用Google Apps脚本在Data Studio报表上设置自动刷新?

Is there anyway to set up auto refresh on my Data Studio report using Google Apps Script?

datastudio报告被投影到我们办公室中的大型显示器上，这就是为什么我正在尝试以任何方式自动刷新报告的原因.

The datastudio report is being projected to a large monitor in our office that's why I am trying any ways to auto refresh the report.

推荐答案

因此，由于将报表投影到我们的办公室监视器中，作为一种解决方法，我尝试创建脚本并将其放置到开发人员工具控制台中，该脚本将自动刷新按选定的时间间隔进行报告.

So since the report is being projected to our office monitor, as a workaround I tried creating a script and placing it to the developer tool console that will auto refresh the report at a chosen interval.

function refreshCases(){
    $(".refreshIcon").click(); 
    setTimeout(function(){
        refreshCases();
    },60000) 
}
refreshCases();

这篇关于使用Google Apps脚本在Google Data Studio上自动刷新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！