...
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.
To access Power BI Service, visit the website https://app.powerbi.com/ and proceed to sign in with your credentials.
After signing into Power BI Service, go ahead and establish a new Workspace (remember to avoid using 'My Workspace'). Then, proceed to add a Dataflow by selecting '+New'.
| Note |
|---|
Remember to avoid using 'My Workspace' as it might not have the option to create a new Dataflow. |
Choose the option to 'Define new tables' and then proceed by clicking on 'Add new tables'.
Choose 'OData' as your data source. To locate it quickly, utilize the Search bar🔎 for easy and efficient navigation.
In the following window, enter the URL you copied earlier in Step 2. For Authentication kind, choose the 'Basic' option and proceed to enter 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). Click 'Next'.
Select the specific tables from Jira that you want to import. After making your selections, click on 'Transform data' to continue with the import process in Power BI Service.
Carry out the necessary data transformations according to your requirements. Once you've completed this step, proceed to select 'Save & close' to finalize your changes.
Importing a substantial amount of data into Microsoft Power BI Service might require some additional time to complete. This is particularly true for larger datasets.
...