Export a list of users from Tableau Cloud

Issue

Unable to export a list of all users from Tableau Cloud.

Environment

Tableau Cloud

Resolution

There are currently two ways to export a list of users from Tableau Cloud:

Option 1

Log in to Tableau Cloud with site administrator credentials (either creator or explorer) will work.
Navigate to the Explore menu from the left pane.
Choose New workbook from the menu dropdown located under the word explore.
A data connectivity window pops up - Choose the TS Users data source from the list and select the connect button in the lower right.
If you do not see the "TS Users" data source listed then use the search in the upper right and search for TS. Then choose the TS Users data source from the list and select the connect button in the lower right.
Expand the user field section in the data pane to see all user fields.
Drag user email and user site role to rows
Select the download icon (down arrow icon) and choose crosstab.
Choose either excel or .csv and select download.
Navigate to the file on the computer in the download folder.

Option 2

Use the Admin Insights Project: The Admin Insights Project allows you to create Custom Admin Views about your Tableau Cloud and using the built in "TS Users" data source you can create a view containing a list of your users and this can be easily exported as a PDF, Image, CSV, Tableau Workbook.

Open Tableau Desktop, under Connect, select Tableau Server.
- Note: If you're not already signed in to Tableau Cloud, in the Tableau Server Sign In dialog box, click the Tableau Cloud hyperlink. Enter your Tableau Cloud credentials and then click Sign In.
In the search box, type "TS." A list of Admin Insights data sources displays.
Select [TS Users] data source and click connect.
Drag User Email and User Site Role to dashboard
Click worksheet > export > excel to export user list as excel file.

Option 3

Using the REST API "Query User On Site" method it is possible to get a list of users on your Tableau Cloud site.

Cause

Tableau Cloud accounts do not have the ability to enable access to the Tableau Server database, so the solution in Exporting User List - for Tableau Server - is not available.