I'm guessing there is a connection or permissions issue occurring.
If this error is occurring only on Tableau Server and not Tableau Desktop, try this to troubleshoot:
- Log in to the Tableau Server machine as the RunAs account.
- Install Tableau Desktop on the Tableau Server machine
- In Tableau Desktop on the Server, create a new data connection to the SAP BW
Does this work? If this fails, what is the error?
I now have the same issue with SQL Server 2012 where its prompting to enter the logon credentials but its not letting me to view the workbook. I use the Viewer credentials option under Authentication while publishing the workbook.
i guess the reason why it is prompting to enter credentials is you might have missed embedding the credentials during publishing the workbook.
Select Server > Publish Workbook, and in the lower-left of the Publish Workbook to Tableau Server dialog box, click Authentication.
In the Authentication drop-down list, select Embedded password.
This allows users to access the view without entering their database credentials.
hope this helps you.
Thanks very much for the reply. I need the viewer credentials to be used while viewing the workbooks since the cube has set with user security.