Integrate Perdoo with Power BI for the ability to push data from Perdoo into Power BI, ideal for reporting on OKRs (or anything that exists in Perdoo's API).
Power BI is a popular business analytics tool from Microsoft, used by companies to keep the pulse of their business with actionable reports and visualizations.
With the Power BI integration, you can effortlessly enrich your data with insights drawn from your strategy execution program.
In this article:
Set up the Power BI integration
Our simple script allows you to pull data on your most important goals from Perdoo to enrich your PowerBI reports.*
The Open API is really powerful, but does require some technical knowledge to build the connections you desire. You'll be able to customize the script to define what you want to pull in, and add your own credentials.
* Please note that this doesn't include the ability to push data from Power BI into Perdoo.
If you require a JWT token and have strict SSO enabled, please contact us below for further instructions.
Do you have an extended example of the Power BI script with additional data to allow more detailed insights?
It's easy to add extra properties in the script, you just need to add them in the queryText variable. What this uses under the hood is our GraphQL API which you can explore in more detail (incl. all field names) here.
Is there any unique identifier of an Objective available to build a better data model?
Yes, there's a field called
idfor this. You can query it for both the Objective itself, as well as its parent.
Is it possible to get an URL of an Objective or Key Result to use it as "Show details in Perdoo" button?
You can't query the URL directly, but it's easy to build using the
idmentioned above. For Objectives: https://web.perdoo.com/#/reports/custom/objectives/s/objective/[id of the objective]/summary and for Results: https://web.perdoo.com/#/reports/custom/results/s/objective/[id of the objective the result belongs to]/summary/kr/[id of the result].
Want to know all the apps we can integrate with?
Here's a full list of apps that Perdoo integrates with. Contact our Support team (firstname.lastname@example.org, or via the in-app chat) to see how we can help you automate updates to KPIs, Key Results, and Initiatives.