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.
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?
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].
What role do I need to have in order to use the integration?
You're limited to the goals you can access to goals that are visible to you in Perdoo. If you can see them in Perdoo, you can access them through the integration.