Advance with Assist: Tableau Power User Leaving the Company


Advance with Assist: Tableau Power User Leaving the Company

Advance with Assist shares quick solutions to common challenges encountered by the InterWorks Assist on-demand team.

Here’s the InterWorks Assist question for this week’s post:

“I have a situation where one of our power users left the company, and I’m having trouble finding the data connections related to them as they aren’t published connections. Is there any easy way to find everything his login is associated with to produce a list?”

I can see where this could come up often. You have many workbooks and views that are built to a connection that isn’t published, but you need to find them and produce a list so edits can be made.

Workbooks Tab

Luckily my client is an InterWorks Assist subscriber, so I can use the Data Source Audit feature from Power Tools: Desktop to look at every data connection in every workbook. I can then export this to a Tableau dashboard, Excel file or PDF. I chose a Tableau dashboard to get the below:

Data Source Audit Results

We can then click into the DataSource worksheet and add the Audit – Connection Username field to find the connection information the client was after and filter to the user he was looking for.Click into Tableau Worksheet

We can then use the Export Worksheet to Excel Option to get the list he was after. I could have also just selected the Excel Option first to get an Excel file of all the audit information, then Column Q is the Connection Username that I could filter on.

Questions? Ask Away.

This was one of many questions that can be solved with Power Tools for Tableau. If you have any questions about Tableau or just data in general, InterWorks Assist is always open.

Learn More

More About the Author

Dustin Wyers

Analytics Consultant / Assist Lead - East
Advance with Assist: Changing Default Properties on Data We receive CSV files from our data provider which we pull into Prep. We then unionize them and output a Tableau online server file. The ...
Introducing InterWorks Assist Now: Live Support for Your Data Needs The Evolution of InterWorks Assist InterWorks Assist was launched back in 2016 for clients who needed quick, personal attention to ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK