Hi , i was able to connect my PowerBI to the Jira server ( reading a project )
however when i am trying to get the epic information ( see the below REST ) i am getting 400 error ( the same REST return results using a browser
any suggestion ?
Hello @Ward Schwillens
And vice a versa: you may create Data Sources in Jira and use them as Import Source in Power B using our Jira plugin: https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=server&tab=overview
More details on Youtube video: https://www.youtube.com/watch?v=6tlx5KzXLeg
Hello @Ward Schwillens
If both are reachable via the network, then I don't see any issue in connecting both. Jira is supported out of the box by power BI
I am attempting to get my Jira data connected to PowerBi. I am confused about the above link because it seems as though it is linking Jira with a browser based version of PowerBi.
I have the PowerBi client installed on my computer and would like to get my Jira data there. Does anyone have any suggestions?
I do have PowerBi desktop installed on my computer and I use it for other things. As for linking my JIRA data to PowerBi I am confused. The initial link at the beginning of this thread doesn't appear to link JIRA data onto PowerBi desktop.
I must be missing something.
Hello Frederico, I opened the template in PowerBI Desktop and I'm able to fill in the credentials, using basic authentication with the same credentials as I normally use. We have Jira Server but it's accessible from the outside. When I have entered all data, PowerBI seems to be making a connection, but eventually I get the error
OLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://myurl:8443/rest/api/2/search?maxResults=500&startAt=0' (500):
Any idea how I can solve this?
Connecting Cloud/Jira to online Power Bi and the following error message appears.
"The expression referenced column 'GetIssues'[Is Resolved] which does not hold any data because it needs to be recalculated or refreshed.
Please try again later or contact support. If you contact support, please provide these details."
I believe it has to do with not having Rest API enabled, if so, how may I enable it?
Hi @Melissa Thornton seems that you are on Jira Server (or Data Center).
Unfortunately, there still not implemented API Tokens functionality.
But you can use API Tokens for Jira to create tokens and keep personal password in secret.
I am a developer of that plugin, so feel free to ask any question regarding it
Hi Pablo ,
I used SQL+JQL Driver and i do same step in the Documentation . i have copied the CVS link but when i try to import this link Power BI desktop as you described i faced a problem that :
"Details: "The credentials provided cannot be used for the Web source. Please update the credential type through a refresh or in the Data Source Settings dialog to continue. (Source at https://jiralocation.com:8190/.)"
I am sure my credentials is right and i am System admin on jira and i granted in the global permission the groups access to SQL+JQL database JDBC connection & SQL+JQL database console access
please let me know if i need to enable any thing further .
I have JIRA on premise + Power BI desktop and have downloaded the "Jira_PowerBI_ContentPack.PBIT" that was floating around in other threads.
I was initially getting the error that was fixed via clearing global data source settings permissions, however the next error i get is: "GetIssuesOLE DB or ODBC error: [DataSource.Error] Web.Contents failed to get contents from 'https://jira/secure/Dashboard.jspa/rest/api/2/search?maxResults=500&startAt=0' (404): . "
I notice this continuously remains unanswered in this thread as other error posts seem to always supercede this. (unless i'm missing a post somewhere?) Please advise on how I can resolve this! thanks!
AIO Power BI Connector for Jira app can be used to easily export Jira data into PowerBI and create the dashboards.
It is available for all the three platforms Cloud/Server/Data Center and is used for hundreds of organizations world wide, including fortune 500 companies.
If you would like us to provide some samples or have any questions, please feel free to email us at firstname.lastname@example.org.
Link to marketplace app page: https://marketplace.atlassian.com/apps/1219072/aio-power-bi-connector-for-jira?hosting=cloud&tab=overview
Documentation link: https://aioreports.atlassian.net/wiki/spaces/APBCFJ/overview
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events