We have several dashboards attached to SharePoint lists via a Microsoft Access database. We designed it this way because these dashboards need to be refreshed, more than once a day. It is not connected "live", but is using an extract.
The database is stored in an area accessible to the Tableau Server service account, and the SharePoint sites the lists come from have granted the service account read/write and contribute permissions. When the extract runs, it times out, with the error message about it taking longer than 7200 seconds.
Does the Access database have to reside on the SharePoint server also in order to work? If not, what might the issue be? Thank you for your consideration.