Can tableau pick the excel data source dynamically instead of physically picking the excel file or is there a way to specify the excel data source path so that tableau picks the data directly.
When you connect Tableau to an Excel Data Source, you have 3 options to connect:
- Connect Live
- Import all data
- Import some data
If you chose to connect live, everytime the Excel file is updated, when you 'Refresh' the data source within Tableau, any changes or new records will be picked up by Tableau.