Summary
Creating a Tableau Data Source files (.tds) from Dremio, will default the connecting port to 9047, regardless if encryption is enabled or load balancer is used, and the port should be changed.
Reported Issue
When generating a TDS file in a SSO-enabled software cluster, the instance URL incorrectly defaults to port 9047. There should be a way to specify the right port as part of the taco file creation.
Relevant Versions
Dremio releases up to and including 24.3.0
Troubleshooting Steps
Add additional content.
Cause
When Dremio creates the .tds file, it creates a property `instanceurl` with the default port 9047. If Dremio has been configured to use an alternate port, Tableau will not be able to connect due to this invalid port.
Steps to Resolve
Open the .tds file in any text editor and edit the instanceurl property to the correct Dremio Authorization URL, which will be the scheme, hostname, and port of the loadbalancer.
Next Steps
Plan an upgrade to a Dremio release greater than 24.3.0
Additional Resources