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.
The only thing I found so far is the plugin called Data Studio Auto Refresh, which is not working.
Is there anyway to set up auto refresh on my Data Studio report using Google Apps Script?
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();
Currently, there is no native / Apps Script based method to auto refresh an opened Data Studio report page.
You can vote for this feature at the official feature request tracker.
You can set data freshness for a data source when adding a new source.
You must be an editor of the data source to change this setting.
You can do this from within a report, or from the Data Sources home page. 1. At the top, click Data freshness. 2. Under "Check for fresh data," select a new refresh option, if available. 3. Click SET DATA FRESHNESS.
You can set a different period of refresh depending on the source. Here is the link to google documentation: https://support.google.com/datastudio/answer/7020039?hl=en
I'm the author of the extension. It works and you can choose intervals. https://chrome.google.com/webstore/detail/data-studio-auto-refresh/inkgahcdacjcejipadnndepfllmbgoag
