...
To export your Jira data to Microsoft Power BI Desktop, follow these steps:
Inside the Data Processor for Jira appSelect the ‘Data Sources’ section in the left-side menu, and then choose ‘Microsoft Power BI’ from the list.
or
On the Home page of the main interface, click the 'Microsoft Power BI' icon.
Locate the specific Data Source you wish to export from the displayed list. Then, hover your cursor over the empty field where the link will appear. Click on this linkto copy it.
At this stage, you have also the option to edit or delete the Data Source by clicking on the three-line button.
Launch Microsoft Power BI Desktop, and in the application, navigate to the 'Get Data' section. Here, select the option for 'OData feed' to proceed with your data import process.
In the Power BI pop-up window, enter the URL you copied earlier in Step 2, and then click 'OK' to proceed.
In the following pop-up, select ‘Basic' and input your credentials. Use the email associated with your Jira Cloud instance for the email field, and your Jira API Token as the password (for guidance on obtaining your Jira API token, please refer to this page).
For optimal authentication, it's advisable to select the most detailed option from the drop-down level list. After making your selection, click 'Connect' to proceed.
...