Sirish, It is great way to visualize Excel data by putting Excel in Box and having Tableau connect to Box directly so you can change Excel source in Box directly w/o having to publish the workbooks. The Box permission works the similar way as how Tableau server connects to other database sources.
- If you want each interactor to enter their own Box credentials before Tableau server shows the data, when you publish the workbooks, make sure to use Live Connection (not extract) and DO NOT embed your password. It also means that you would need to setup permissions twice - on both Tableau server workbook level and also Box Excel file level.
- if you want each interactor to view the dashboard w/o entering their credentials anymore (since you already setup workbook level permissions on Tableau server and assuming that users have their SSO already when come to Tableau sever dashboard name), all you need is to make sure embed your password when you publish the workbook. Like this below