The TableauMagic DataTables Extension v1.0.0 is now available for general use; if you have Tableau Desktop 2018.2 or greater, all you have to do is download the .trex file and start using it in your dashboards today. Click HERE download.

Usage

  • Create a worksheets with the data you want displayed in the DataTable. 
  • Add the worksheet to a dashboard. 
  • Drag an Extension to the dashboard and use the downloaded trex file.
  • Configure the Extension and connect it to a worksheet. 

Note: This extension by design listens for actions and filters on the connected worksheet; this means you can have multiple worksheets with various visualisations filtering the Extension connected worksheet.

About

The TableauMagic DataTables Extension was created to:

  • Improve my understanding of this wonderful Tableau functionality.
  • Leverage the widely used DataTables.net libraries in Tableau dashboards.
  • Provide an open source example for others to look at, learn from, and improve upon.
  • Have some serious fun.

I have open-sourced the code under the MIT license; you can find the link to the GitHub repository here: https://github.com/tableaumagic/tableau-datatables-extension

If you think there is anything I can improve on, please let me know at via Twitter at @thoang1000, or via email at admin@tableaumagic.com

Install Guide

To install the code and get up and running:

  • Install Node.js and NPM
  • Install Yarn
  • Install Git

Once installed, clone this repository:

$ git clone https://github.com/tableaumagic/tableau-datatables-extension.git

Run the following yarn command to install the required third-party libraries:

$ yarn install

Use npm to install a http-server

$ npm install http-server -g

Start the http-server

$ http-server

Open the datatables.trex file from the cloned GitHub repository in Tableau Desktop 2018.2 or greater. Enjoy.

Credits

Thank you to the wonderful people of the Tableau community for providing me with feedback, special thanks to:

  • David Pires @davidmpires
  • Josh Tapley @josh_tapley
  • Rajeev Pandey @rajvivan

24 COMMENTS

  1. This is a fantastic extension!! When I tried to use this extension, it only pulls 10000 rows though, is that the limitation, is there a way to bypass this limitation?

    Thanks so much for this.

  2. Seems like an excellent little plugin!
    From a data security standpoint, is any data transferred to you for processing or is it all done at the Tableau server level?

  3. Hi Toan,
    Your extension works well for dashboard with single worksheet and it’s pretty amazing!
    We’ve encountered below scenario and need your guidance on that:
    We’ve around 4-5 worksheets in a dashboard which shares common column(dimension) among them, would it be possible to create a single excel table which will show data from all 4-5 worksheets as it is on Tableau dashboard?

    • If you can create a Worksheet with the data, then yes; this Worksheet does not even need to be visible, you can have your visible worksheets and an additional floating Worksheet which can be resized to be invisible.

  4. the extension works on desktop but it doesnt dispay any data once published on server. I granted permission and all, any ideas?
    Also, is there a way to show the number of row drop down menu with the plug ins?

      • Toan, thanks for the quick response. When you say whitelist, you mean granting access through server>settings>extensions? I have done that, granted full data access but it didnt fix the issue. Is it because I have actions set up for the data sheet? The action is set to exclude all values unless I click on the table.
        I don’t understand why it works flawlessly on my desktop but not online.
        thanks for all the help.

          • I believe the issue is that once it’s published, the extension does not update with the underlying data once I filter it using actions. For instance, my action is to exclude all data unless I click on a table, once I click on the table the raw data populates. I think the issue with the extension is that the raw data is not populating because it was initially published by excluding the data unless action is taken. How could I possibly fix that?

          • I will need to look at that, it will likely require some small modifications to the javascript code. I assume that you are hosting the extension internally?

          • Yes we are hosting it internally on server and embedding the dashboard. What can I do to help you with this? thanks for all the help

  5. I’m having some trouble getting the data to download when I hit the Plug-in buttons. When clicked they take a few seconds and look like they’re pressed but then nothing pops up.

    Am I missing something?

  6. When Choosing a filter, the data table is not getting refreshed. The old data appears as such. Kindly help in refreshing the data table on filtering values in dashboard.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.