Web Data Connector for Tableau Public
Tableau Public is a great platform for showcasing your data visualisations. Now you can also start analysing the data about all your visualisations with a new web data connector (WDC) that I created. With the Tableau Public WDC you will be able to get insight into the number of views, favourites and other information related to your published dashboards.
For anyone that wants to jump in immediately:
- Copy this link: https://tableau-public-api.wdc.dev/
- Open up Tableau and click ‘Web Data Connector’. You can use any version since v9.1. This is the version where Web Data Connectors were introduced.
- Find your Tableau Public Username. If you go to your Tableau Public page you can find it in the URL.
- Enter your username and Tableau will start getting your profile data!
If you get stuck please click on the ‘About’ tab on the WDC page to read a step-by-step instruction on how to find your Tableau Public account.
Background to the WDC:
The Tableau Public API is a bit of a hidden API. It’s not officially documented anywhere except for a few really good blog posts from community members. You can read more about the API in Jeffrey Schaffer’s blog and Marc Reid recently wrote an excellent blog about it. I would highly recommend reading Marc’s blog because he built a complete dashboard based off the data which is a great starting point. This dashboard also demonstrates many of the new features in Tableau’s latest release (version 2019.2).
Want to get data for multiple users?
That’s possible! Please provide a comma separated list of username. You can enter that in the same text input box as where you put the username in step 3. I haven’t really tested what the maximum number of users is. So please break it and report back!
Can I refresh my data?
Yes, you can if you use Tableau Server. You can set up a refresh schedule and refresh the data. Every web data connection in Tableau is an extract. Therefore you are setting up an extract refresh schedule. This also means your data will not be ‘live’ but you can of course set the web data connection to refresh near live.
If you publish a workbook that relies on a web data connection on Tableau Public you can unfortunately not setup an extract refresh.