All articles

BI Export in Wrike

Table 229. Availability - Legacy plans


Overview

Enterprise account owners and admins with the right to “Export account data” can export analytics data.

BI Export lets you export your account data for future import to third-party analytics tools (e.g., PowerBI or Qlik). This allows for building reports and analytics that aren't available in Wrike and merge Wrike data with data from other sources. The exported data includes, but isn't limited to:

  • Projects

  • Folders

  • Tasks

  • Users

  • User groups

  • Timelog entries

  • Workflows

  • Activity log

  • Custom field history

  • Status changes

  • Effort fields

The data is stored in tables, which are connected using foreign key identifiers (like in a relational database). Each table is stored as a separate CSV file. Documentation for data schema and tables can be found here.

Note

All account data is included in the CSV files, not just the data shared with the admin.

Export BI data

You can export BI data in one of two ways: by using REST API or the account backup tool. Using backup is recommended for manual export, while REST API can be used to automate the process.

Note

BI Export data is automatically updated once per day. You can use API to check if new data is ready for export.

Export using REST API

  1. Authorize to API v4.

  2. Call the /data export API method.

  3. Use the links in the response to download files with BI Export data. The links expire in seven days.

Note

More information on this export method can be found here.

Export using the backup tool

  1. Check the Include BI export in backup box in the Settings section of Account Management.

  2. Download and run the backup tool.

  3. The backup folder will contain BI sub-folder with a collection of CSV files.

Top