itil

ITIL Reporting

excel

ITIL 4

excel

Power BI

excel

Excel Formula | Macro | Script

Power BI: connect to the Jira eazyBI API report

Using eazyBI in Jira Cloud, I can import data from reports located in the analyze tab but not from the dashboards one:

power bi

Before to start, I will need my Jira account and token. Now, I will have to create a report and once done, click on the “3 dots -> embed report”:

power bi

From the popup, I will need to copy the URL:

https://aod.eazybi.com/accounts/111111/embed/report/2222222

power bi

Then I will have to replace “embed” by “export” and add at the end the extension “.xls” to export it in an excel format so it will look like that:

https://aod.eazybi.com/accounts/111111/export/report/2222222.xls

NOTE: do not put the “xlsx” extension since it is not supported yet at the moment I wrote this article, more information, go to its official webpage eazyBI report results export API

In Power BI Desktop, click on “get data -> web” and put the URL:

power bi

I will have to authenticate:

power bi

Once done, my eazyBI data will be loaded. Before to load it, I can add in the URL some conditions/filters, for more information, go to its official webpage eazyBI report results export API.

Useful eazyBI links:

I have to say that, using eazyBI, I was interested to get the Xray test plan overall execution status:

power bi

The result corresponds to the “latest status” based on the “final statuses have precedence over non-final” option:

power bi

But as we can read, unfortunately this option is not available for Jira Cloud !!!

Interesting Topics