- OBIEE DSN for Tableau Desktop is not the same as the OBIEE DSN in Tableau Server.
- Tableau Server is being run as a service with a Windows User account which has one of the following issues:
- The windows user (or service account) does not have Admin privileges for the machine
- Tableau server is not "Run as User" with a windows user with admin privileges
- BI Connector license is not registered/activated for the Windows user account that is used to run Tableau server.
- Please check if the pre-requisites for BI Connector Server Edition are met.
- Specifically, please check the following:
- Stop the Tableau Server service
- Configure the Tableau server to use Run as User account
Restart the Tableau Server service.
- Next Step is to check if the BI Connector Server Edition has been registered with the license key for the Windows User used for Tableau "Run as User".
- Login to the Windows Server (where Tableau server is installed) with the Windows user account that you used for "Run as User" in Tableau.
- Search for ODBC in your Windows PC and it will bring up the ODBC Data Sources
- Launch ODBC Data Sources (64-bit).
- Select the OBIEE DSN that you configured earlier and click Configure to launch the BI Connector UI.
In the BI Connector UI, check if the License type is valid. It should display License information as shown below. If not, click on Activate License icon.
Enter the new License Activation Key and click Activate.
- Connect from Tableau Desktop to Tableau Server and publish the worksheet again.