Hi everyone,
I'm using an Excel file as a data source for Looker Studio. The Excel file is stored in a shared drive and has multiple tabs. I'm creating a different data source connection for each tab. The problem is when I add a new tab, the available Excel file is Looker does not recognize the new tabs. Additionally, the data doesn't update automatically when I edit the info on the already existing tabs. I wonder if this has to do with the 12 hours data freshness, i.e. Looker will only fetch the new updates each 12 hours? Is there any workaround for this? Does anyone know if this feature will be improved in this regard?
Thanks!!