3 Replies Latest reply on Jan 29, 2019 2:59 AM by Mihai Constantinescu

Identify All Worksheets Sourcing from a Data Source

Sujay Paranjpe Feb 28, 2017 4:45 PM

Folks,

If I need to know which all worksheets are sourcing (or built using) from a particular data source, is there an easier way to know.

For example, if I have built 15 worksheets from data source A then is there any way I can get a list of it? May be, use Document API? I am not sure. Any help will be useful.

Best,
Sujay

1. Re: Identify All Worksheets Sourcing from a Data Source

Keith Troutt Feb 28, 2017 7:55 PM (in response to Sujay Paranjpe)

Hi Sujay,

I would recommend looking into Power Tools for Tableau
https://www.interworks.com/solutions/business-intelligence/data-visualization/power-tools-tableau

It will run an audit of all your workbooks and tell you what data sources they are connected to. It also works with Tableau Server and Tableau Online.

The data source audit was well worth the price. Here's a screen shot of what the data source audit results dashboard....
Good luck,

Keith
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Identify All Worksheets Sourcing from a Data Source

Sujay Paranjpe Feb 28, 2017 8:27 PM (in response to Keith Troutt)

Thanks Keith. It helps.

Best,
Sujay
Like Show 0 Likes(0)

Actions
3. Re: Identify All Worksheets Sourcing from a Data Source

Mihai Constantinescu Jan 29, 2019 2:59 AM (in response to Keith Troutt)

Or you can build your own for free using the Tableau Postgres tables - e.g. _datasources, _data_connections, _workbooks, _view_stats
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Identify All Worksheets Sourcing from a Data Source

1. Re: Identify All Worksheets Sourcing from a Data Source

2. Re: Identify All Worksheets Sourcing from a Data Source

3. Re: Identify All Worksheets Sourcing from a Data Source

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account