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:
Custom field history
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.
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.
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 a response to download files with BI Export data. The links expire in seven days.