Loading JIRA data into PowerBI desktop


I am trying to load JIRA data into Power BI desktop but its trowing an error, as I have on-premise link not a cloud link that is why I can not connect JIRA data through PowerBI content pack.

So if any one come across the same issue of loading JIRA data into power bi desktop then please share your thoughts.

2 answers

0 votes

Hi Pankaj,

This blog post mentions JIRA Server and Cloud, so it seems that it should work. Could you let us know what error it is that you're getting? Do you have a screenshot of the message?

Thank you!

Kind Regards,

Hi Shannon,

I am trying below link


for my URL to have JIRA data into power bi desktop but after populating URL once I click on Load button then its showing me error...

Scrren Capture.PNG


and moreover its not loading any data into it only showing blank template.

So is there any other way to extract data out of JIRA for Power BI charts/reports?

Hi Shannon,

If the above details is confusing then you can go through the below error message which I am getting while connecting JIRA data with power bi

I'm using an on premise version of Jira. After following the instructions given here I'm getting the following error after refresh:

"OLE DB or ODBC error:[Datasource.Error] Web contents failed to get contents from 'http://xxx.xxx.xxx.xxx:xxxx//rest/api/2/search?

maxResults=500&startAT=0' (404):not found."


The fields are there but none of the data. Any insight would be appreciated. Thanks for your time.


Thank you for that. I'm not familiar with PowerBI but the error seems to be coming from PowerBI and not Jira. I found many posts in the Power BI community page with this error, specifically this one mentions Jira as well:

Error: We found extra characters at the end of JSON...

Have you been in contact with Power BI about this? Perhaps they have a solution or a suggestion for you?

Kind Regards,


You are correct!! the issue was from Power BI side not from JIRA so I successfully managed it.

Thanks for your time and support.





What was the solution? 

Hi Pankaj,

Can you share how you fixed this issue on Power BI? i am new to using Power BI for JIRA reporting and I am getting the same error message as the one you faced.

Please share the solution.



0 votes

Can PowerBI import Excel files?

If so, then you could export JIRA data to export with the Better Excel Plugin.

Thanks for the suggestion Aron.

Using "Better Excel Plugins" I can do that but what about data refresh?

I have to do it manually every time whenever new data comes or else I have to be dependent on more plugins for these functionality to work.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 13, 2019 in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

742 views 0 12
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you