My report seems to be constant refreshing itself, which in Google Sheets takes forever to process (I have formulas and such that point to the data).
Why is it refreshing when I haven't asked it to? I set up a trigger so it should only refresh at 2a. Right now, I just want it to load so I can refresh my data in Data Studio, but when it gets just about done, it starts refreshing again. Any tips? This is very frustrating.
this shouldn't be possible. Could you please check your triggers to see that you don't have some that you have forgotten about:
I've determined that it constantly refreshes if the sidebar is open, even if I don't click the button to refresh the report. This is very annoying if I don't close the sidebar quite fast enough, as it takes a long time (maybe half an hour) to fully execute.
can you please record us a video of it. Thanks!
For example with this Chrome Browser add-on: