How does updating sheets used as data source not play nicely with dat studio? I would expect the report to update when the sheet changes, at least when the report is reloaded. Is this what is happening?
Right now, because of caching the update can take up to 12h. But you can manually update the data source to bring the latests data from the spreadsheet.
Thanks for the heads-up. That would indeed cause an interesting confusion if not known to the users. We could probably live with it for some use cases, a more direct update would be better though.