Skip to main content

#Tableau Server80 discussing

We have 100+ datasources in our onprem tableau server, We need the list of datasources connected in this server, Kindly help to get that list by exporting over GUI or Linux command line. 

 

#Tableau Server

2 answers
  1. Yesterday, 12:17 PM

    @Silambarasu Anbu

     

    Hi, you may use tableau server client: 

    https://tableau.github.io/server-client-python/docs/

     

     

    You may use a PAT: 

    https://help.tableau.com/current/pro/desktop/en-us/useracct.htm#create-a-personal-access-token

     

     

    The code look like this:

    import tableauserverclient as TSC

    import csv

    # Creds

    HOST = "https://10ax.online.tableau.com/"

    #Your PAT Name

    TOKEN_NAME = "Python"

    #Your PAT Value

    TOKEN_VALUE = "tm5==hRdo"

    # Use "" for default site

    CONTENT_URL = "yoursiteuri"

    tableau_auth = TSC.PersonalAccessTokenAuth(TOKEN_NAME, TOKEN_VALUE, site_id=CONTENT_URL)

    server = TSC.Server(HOST, use_server_version=True)

    fds = open('datasources.csv', 'w', encoding='UTF8', newline='')

    dswriter = csv.writer(fds, delimiter=";")

    dsheader = ['Name','Project','content_url','owner_id','ds_host','ds_port','ds_connection']

    dswriter.writerow(dsheader)

    with server.auth.sign_in(tableau_auth):

    all_ds = server.datasources.all()

    for ds in all_ds:

    ds_item = server.datasources.populate_connections(ds)

    for conn in ds.connections:

    row = [ds.name,ds.project_name,ds.webpage_url,ds.owner_id,conn.server_address,conn.server_port,conn.connection_type]

    dswriter.writerow(row)

    fds.close()

    server.auth.sign_out()

     

    If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you. 

     

    Regards, 

     

    Diego Martinez 

    Tableau Visionary and Tableau Ambassador 

0/9000

On premise Tableau. 

 

The scheduled extract runs but does not pick upp additional csv files. 

 

I use desktop to point a datasource at a folder with csv files. The datasource is published and extract scheduled. 

 

To update the datasource with new csv files I have to run an extract from desktop. 

 

Should the scheduled extract pick upp new csv files? 

 

#Tableau Server

19 answers
  1. Yesterday, 7:49 AM

    Thanks - this is not good news, but it is good progress and a relief that you have reproduced the problem so that I can stop trying and find another way. 

     

0/9000
4 answers
0/9000
4 answers
  1. Aug 18, 11:07 PM

    Hi @Gerika Jacobs

     

    I'd say it is a Tableau side rendering timeout. 

    Defined by the key value  

    tsm configuration get -k vizqlserver.querylimit 

    which is per default 30 minutes 

    Why it is timing out / very slow, is another story, if it is a live connection to Postgres then the (generated) query performance or data volume is bad.

0/9000

Hi, 

In my prev company we used tableau cloud and snowflake and I think automatically we had tagging on all our queries with tableau. 

Now I'm using

Tableau server with BIgQuery

, we enabled query tagging with following  command yesterday but I don't see any tag on the queries. 

tsm configuration set -k native_api.UserInfoInGeneratedSQLEnabled -v true  

Someone encountered it and know how to solve it or have suggestion to what to check? 

 

#Tableau Server

3 answers
  1. Aug 18, 8:12 PM

    Hi @Sagi Tsaeiri

     

    I must admit I don't have a GBQ instance at hand to test but I'm not sure why it doesn't work like any other SQL platform based connector. Maybe it only works with the Google Big Query (JDBC) connector if you want to try.

0/9000

Hello everyone, 

 

since I replaced my data source with a new SQL, I keep getting this error message: 

 

Aktion konnte nicht ausgeführt werden 

Error executing subquery id: "36165" 

Fehlercode: 1B885FB3 

Logical Query missing field [__measure__2] from joinOp. This is an invalid query.

 

What's causing this? Can you help me? 

 

Thank u so much! 

 

#Tableau Server

1 answer
  1. Aug 18, 7:44 PM

    @Demet Akbas

     

    Please be more verbose with your situation. Are you working in Tableau Desktop ? By "new SQL" you mean a custom SQL statement ? What's your connector type ? The error seems to come from a join condition from the logical layer. So you can check that. if not, a screenshot of your Datasource model would be helpful at first.

0/9000

Hello Everyone, 

 

I have a hierarchy table and the measure columns with labels like below keep changing their position depending on my hierarchy level. However, I want the labels to stay intact. Can someone help me here please. I attached the tableau workbook file 

 

How to retain the measure label in a hierarchy layout

 

#Tableau  #Tableau Desktop & Web Authoring  #Format Column  #Tableau Server

3 answers
0/9000

Hi Team , 

I am brand new to Tableau , looking for some assistance on license part. I have got Tableau creator license from my team and I am able to login Tableau online/Cloud. Now I am looking for Tableau server setup, So can we use the same license to setup server also?? is my ask. 

 

Thank You 

 

#Tableau Server

2 answers
  1. Aug 12, 12:47 AM

    @Divya Jayachandra

     

    Hi, when you initially buy a creator license, you should be asked if you are going to use Tableau Server or Tableau Cloud.  A creator license can only be used for Tableau Server OR Tableau Cloud. It can't be used to activate at the same time Tableau Server and Tableau Cloud. 

     

    If you want to activate Tableau Server, you would need to buy another creator license, and therefore make sure to ask the Tableau Account Manager/Tableau-Salesforce partner it is a new install, and you need it for Tableau Server. 

     

    Once you have enabled Tableau Cloud or you have installed Tableau Server, you can activate Tableau Desktop and Tableau Prep Builder using LBLM 

    https://help.tableau.com/current/desktopdeploy/en-us/desktop_deploy_activate_license.htm

     

     

    On the other hand, if you are looking for the tenant portal in Tableau Cloud (Tableau Cloud Manager), your user needs to be configured as a Cloud Administrator: 

    https://help.tableau.com/current/online/en-us/cloud_manager_intro.htm

     

    https://help.tableau.com/current/online/en-us/cloud_manager_users.htm#manage-site-membership

     

     

    If you are a Cloud administrator, once you have signed in into your Tableau Cloud site, you will find a site selector in the upper left corner, just below the tableau, and the option to sign into the Cloud Manager will be enabled.  

     

    Hi, when you initially buy a creator license, you should be asked if you are going to use Tableau Server or Tableau Cloud. A creator license can only be used for Tableau Server OR Tableau Cloud.

     

    If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you. 

     

    Regards, 

     

    Diego Martinez 

    Tableau Visionary and Tableau Ambassador 

0/9000

Hi all,  

 

Over the past few months, we've been getting sporadic data server process crashes (requiring a tsm restart to fix). We run a single node with Ubuntu 22.04 with 70GB RAM. Online research seemed to suggest data heavy live connections at the same time could cause it, however all connections have been updated to data extracts - since this, the crashes have reduced but they still occur.  

 

Any ideas on how to stop them? Logs seem to show they can reach like 22GB before they are killed. 

 

Thanks 

 

#Tableau Server

6 answers
  1. Aug 17, 12:05 PM

    Hi @technical Department

     

    yes both tsm commands works together. You need to enable the limit and set the limit. Feel free to test on your sandbox or test system. But 5 GB per process is not a lot. It will apply to each process individually including VizQL, Backgrounder and Hyper for example. 

    If you want to make progress, you have first to learn to know your instance, meaning setting up some advanced monitoring. Then you can decide if you want to do vertical or horizontal scaling, or hard limit processes.

0/9000

A few of our users with Viewer site role are reasonably sure in the past they were able to create their own subscriptions and if I look at items under schedules that were setup this seems to be the case.   I am unable to find anything solid in the documentation indicating that a viewer role that was able to export/download pdf permissions on a workbook would not be able to do this, the api guide references appropriate role/permissions and it has all been setup and enabled at the site level.   The user with a viewer role can see the option and is able to do everything but select a schedule, the drop down llist is empty. 

 

It works fine for the same user if I assign them an explorer role.   

 

Currently on a Windows Server install running 2025.3. 

 

#Tableau Server

1 answer
0/9000