Even though we mostly work from a variety of databases, Excel worksheets still end up being data sources for some of our Tableau visuals - both as embedded one-time data sources and also shared, refreshed Server-based 'official' Data Sources.
Is there any way I can view details about the connection via Tableau Server?
Even just being able to view the full UNC filepath would be very useful.
Am I missing something here, or is that detail simply not viewable/modifiable on Server for Excel files?
(Running Server 10.0.2)
Check the data_connections table where dbclass begins with "excel" e.g.
Select * from public.data_connections where dbclass like ('excel%')
The fields to use in order of preference: