Querying Tableau workbook permissions for all groups and users with Python and the REST API

Data governance can be hard.
In this tutorial we'll explore one way to automate the process of identifying exactly who (groups and users) can do what as far as workbooks are concerned in your Tableau environment.

Medium tutorial article on triggering extract refreshes:

For more written tutorials, check out the Medium blog posts!

Python version used: 3.8

To make sure you have all the latest features, update tableau-api-lib:
pip install -U tableau-api-lib

Join the Tableau Developer Program to get involved. It coms with a free Tableau Online developer site!

[laurastone-xq]

When using python version 3.10 and above I get a pagination error -- "The Tableau Server REST API method decorator did not return paginated results. Please verify that your connection is logged in and has a valid auth token." I have tried to pip install upgrade for tableau_api_lib but nothing seems to work. Any suggestions on how to get past this issue?

[fabersoaks]

Hey @Devyx, can we modify this to get a data frame with all workbooks inside a particular group and a User?

[kunalbose]

If we have tableau data source file and we want to update some formula like we have profit or something like that

[kunalbose]

Please make videos of Tableau document api python also

[workperson]

I was running the code in jupyter but after fetching a certain number of group permissions for workbooks, suddenly I got this error!

KeyError Traceback (most recent call last)
Input In [12], in <cell line: 32>()
33 print(f"fetching group permissions for workbook
34 response =
---> 35 permissions_df =
36 if "group" not in permissions_df.columns:
37 continue

KeyError: 'granteeCapabilities'

Can you please tell why is this error poping up?