All articles

BI Export

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

Overview

BI Export lets you export your account’s data for future import to third-party analytics tools (e.g. PowerBI or Qlik). This allows for building reports and analytics that are not available in Wrike and merge Wrike data with data from other sources. The exported data includes, but is not 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). Documentation for Data schema and tables can be found here.

Important Information

  • All account data is included in the .csv files, not just the data shared with the admin.
  • BI Export data is automatically updated once a day. You can use API to check if new data is ready for export.

Export BI Data

You can export BI data in one of two ways - 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.

Export using REST API

  1. Authorize to API v4.
  2. Call the /data-export API method.
  3. Use the links in a response to download files with BI Export data. The links expire in 7 days.

Export using the Backup Tool

  1. Check the “Include BI export in backup” box in 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