1 of 1 people found this helpful
Hi There -
The Run-As domain account that the Tableau Server service is running under must be able to access the location where that Excel file is stored.
So regardless of whether the document is stored on the remote SSIS box, or stored locally, you need to be sure the domain account that Tableau is running under has permissions on the folder or share.
You might be able to get this to work with a NT "pass through" account - an account that you define on both networks with the same username and password - I've had some luck with that before. Or, can you consider some other way to get that Excel file over TO the box where Tableau Server is running?
For example, maybe you can add another task to your SSIS package to "push" the excel file to the Tableau Server box...or maybe you could drop it into a (HACK!) DropBox folder that also exists on the Tableau Server machine?