All articles

Wrike Power BI Connector

Overview

The Wrike Connector for Microsoft Power BI lets you pull data efficiently from your Wrike account directly into Power BI, making the Wrike data objects available for your reporting purposes.

You can pull the data, in the form of account-level datasets, space-level datasets, and project/folder-level datasets. You can drill down through your Wrike space/project/folder hierarchy in the Wrike Connector and select your required datasets for your preferred space, project, or folder. This will let you create focused analytical reports for your target space/project/folder, without the need of manually filtering the data of your entire Wrike account.

Tip

If your reports require relationships to be built between datasets, you can use the following Wrike Data Model (ERD) as a reference to understand the possible relationships between the various columns of the available datasets. You can also use the following test report as a reference on how to create simple Wrike reports in Microsoft Power BI.

How to get access to the connector

The connector is bundled with all releases of Power BI Desktop starting from the May 2023 release. If you do not see the connector available in your Power BI Desktop, please update it to any version released on or after May 2023.

Note

Although all Power BI Desktop users will be able to see the Wrike Connector, only users with the Enterprise Pinnacle plan can use the connector.

Available data

What are the data objects available through the Wrike Power BI Connector:

  • Spaces, projects, folders, tasks

  • Custom Fields

  • Finance Fields

  • Job Roles

  • Access Roles

  • Bookings

  • Approvals

  • Attachments

  • Invitations

  • Contacts

  • User Groups

  • Timelogs

  • Workflows

  • Custom Item Types

  • Work Schedules

This connector uses Wrike’s API to fetch data. Most of the Wrike objects are available through this connector, however any data object not available through it can be directly queried to Wrike’s API through the Microsoft Power BI and the resulting data can then be merged with the data available through the connector.

Tip

Reports created by using the Wrike Connector can be published in Microsoft Power BI Service. Such published reports can also be scheduled for auto-refresh. Wrike is available as a Connection Type for Cloud Connections in Power BI Service.

What's next?

Top