LogoAsinariaHamburguer Icon

2 min read

Export Your Jira issues to PowerBI Without Extra Tools

Updated March 6th

In this post, we'll guide you through the process of importing Jira issues from a project into PowerBI, leveraging the API. You won't need any additional tools or coding expertise.

However, field formatting will be necessary, which we won't cover here. For those looking for a simpler solution, you might find using a free connector like Asinaria to be more convenient. Click the button below to sign up!

To import your Jira project data, we'll use the 'Web' import feature in PowerBI Desktop. Just click on this option to initiate process.

powerbi screenshot get data

PowerBI will display a Window. Select the "Advanced" option. You should see a screen similar to the following.

powerbi screenshot popup

In the URL part, you will have to insert the Jira API URL for retrieving issues. You can go and check the documentation over here. Or you can just copy the following, it will work right away:


Replace YOUR_DOMAIN with your Jira domain. To get it, just go to Jira and check the URL

jira screenshot url

You should see a link that looks like this one. The text before atlassian is the domain


Now you'll need to replace YOUR_PROJECT_ID with your project's key which you want to import issues from. To get it, go to your project and select the Project settings view

jira screenshot focus on project settings option

Then copy the key located just below the Key label

jira screenshot key

Replace that Key into the URL, and paste into PowerBI. It should look similar to this:

powerbi screenshot url filled

Now, in the 'HTTP request header parameters' section, type Authorization in the left box.

powerbi screenshot aurthorization

In the right box, you'll enter the authorization token. I'll guide you on how to get it. In Jira, click your profile at the top right. Then, choose Manage account.

jira profile menu manage account

Next, navigate to the 'Security' section in the top bar. Click on Create and manage API tokens.

jira security section

Click the Create API token button, and name it, then click Create. Copy and save the token somewhere safe.

jira api token copied

Use the token to create a base64-encoded string using the format email:jira_api_token. You can search for an online base64 encoder or use the tool below. Don't worry, your information is secure! be sure I don't save any data.

Generate you base 64 token


Copy the generated base 64 string. And back at Power Bi, in the right box write Basic your_generated_string, Click OK

powerbi form filled

If PowerBI greets you with another window. Just go with the default options and continue. If all goes well, PowerBI will load a table similar to this one:

powerbi screenshot issues imported

Be aware that you might encounter some challenges with certain properties. To resolve these, you'll need to utilize additional PowerBI features designed for data customization and correction.

If you're looking to import your data quickly and effortlessly, without the hassle of extra steps, asinaria.com is your go-to solution. Simply click on the button below to sign up. asinaria.com will generate a pre-formatted link for you, ensuring your data is perfectly organized and ready for immediate use in PowerBI.

Copyright © 2024 Asinaria. All rights reserved. - Terms of Use - Help
Privacy Policy - Data & Security