BI Export in Wrike
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.
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.
-
Authorize to API v4.
-
Call the /data export API method.
-
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.