I am hoping to build a dashboard in Tableau Online based on Smartsheet data that must be extracted/updated on a regular cadence (~once per day). I built the dashboards in Tableau desktop and pulled in Smartsheet data using the Web Data Connector, but once published online, the Tableau dashboards cannot seem to refresh the data from Smartsheet. Does anyone have any workarounds here? I suspect it has to do with the need to log-in to Smartsheet to access the data, but have not found an effective solution.
Happy to provide follow-up as needed to clarify any details.