KNOWLEDGE BASE

Increasing Admin Insights Data Beyond 90 Days


Published: 15 Feb 2019
Last Modified Date: 20 Apr 2021

Issue

Tableau Online’s Admin Insights retains data for the previous 90 days by default. Some scenarios may require data going back further than 90 days.

Environment

  • Tableau Online
  • Admin Insights

Resolution

There are multiple ways to retain Admin Insights data for longer than 90 days.

Option 1: Tableau Prep Builder Output to Data Source or External Database

Using Tableau Prep Builder, connect to the desired Published Data Source in the Admin Insights project. In the Prep Flow, include an Output to either a new Published Data Source or directly to an external database (Prep Builder version 2020.3 or newer required). This will write the Admin Insights data to that location. If you choose to publish to Tableau Online, make sure not to overwrite the existing Admin Insights Published Data Source. If you do, your data will be overwritten the next time the data is updated.

Publish the Prep Flow to Tableau Online, and using Data Management, set up a recurring schedule to append new data. (If you do not have Data Management enabled, you can refresh the Prep Flow manually or from the command line.) Whenever the Prep Flow runs, data will be written to your new Published Data Source or external database. Repeat for all required Admin Insights data sources. Note: Depending on your needs, you may want to leverage an incremental refresh.

Optional: Tableau Prep allows you to incorporate other data sources in your Flow. You may want to add supplemental user attributes to enrich the Admin Insights data.


Option 2: Download the data via REST API

Using the REST API, download the Admin Insights Published Data Source. The resulting .tdsx file will contain all data in the data source at the time of download. Save this file to a location that you will be able to access at a later date. Then use your preferred scheduling tool to automate this process moving forward.

When needed, you can open this file with Tableau Desktop to understand the actions that took place in the time period included in the .tdsx file.

Option 3: Download the data manually
 
Navigate to the Admin Insights Published Data Source and select “Download” from the menu next to the Published Data Source. The resulting .tdsx file will contain all data in the data source at the time of download. Save this file to a location that you will be able to access at a later date. 

When needed, you can open this file with Tableau Desktop to understand the actions that took place in the time period included in the .tdsx file.

Cause

The ability to increase the Admin Insights data retention past 90 days is not yet built-in to the product. 
Did this article resolve the issue?