Display powerBi in JIRA

[Diet Bos]

Good Afternoon all,

So it is obvious that you can export from Jira to powerBi, but how about the other way around.

We have a powerBi page that our customers use to have an overview on backorders and dates, now we would like to create a platform that shows the backorders from the powerBi page (per customer) and if a questions excists the can create a ticket/question. 

The source for powerBi is Microsoft Dynamics AX2012 - for the future we are looking at implementing dynamics 365.

any comment is appreciated!

[Christopher Maxwell · Accepted solution]

Hi Diet,

Welcome to the Atlassian Community! And, great question.

Let's start with the bad news...

No standard functionality, or connector, currently exists to connect PowerBI -> Jira.

Yet, as you already know, there are ways to go from Jira -> Power BI.

I checked with developers of "Power BI Connector for Jira", and they confirmed that their app assists with extracting information FROM Jira into PowerBI, but that there is no possibility of connecting Power BI back to Jira.

Microsoft has a list of default connectors for Power BI, and Atlassian Jira is not listed:
https://learn.microsoft.com/en-us/power-query/connectors/

Now, some good news.

Both Jira and Power BI provide REST API connectors. I recommend you explore the possibility of creating an application within Power BI's Developer Portal that would enable you to then connect into Jira vis REST API and create tickets in Jira. Atlassian provides documentation on how to use the REST API to create a ticket within Jira:
https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/

Here is a resource providing several options for REST API Power BI integrations:
https://hevodata.com/learn/rest-api-power-bi/

After you have created an app for Power BI -> Jira, you may find others who are also interested in such an app.

Hope this helps,
Christopher

(by the way, if this helps answer your question, please be sure to mark it as 'answer' - which not only helps classify the forum question as having been 'answered', but also helps me on my quest to become an Atlassian Community Leader)

[Christopher Maxwell]

Hi @Diet Bos ,

I wanted to check back in with you and see if you question has been answered or if there is more to be worked through? If you are set, it is helpful if you can mark the ticket as answered.

Have a great week,
Christopher

[Diet Bos]

Good Morning Christopher,

I completely missed your answer which to me is very helpful. I will accept this answer as being the current thruth and hopefully this will help you on your endeavors to becoming the community leader!

Regards

Diet

[Christopher Maxwell]

Hi @Diet Bos ,

Great, thank you! I wish I would have had better news for you, though.

Also, marking the post as being answered helps with properly noting whether an issue is still open or not. I know for myself (and I believe a number of the Atlassian Community Leaders) --- I will generally search through all the open tickets and filter to the ones that have not yet been answered to see which tickets I may be able to help someone with.

Have a great week,
Christopher

[Diet Bos]

@Christopher Maxwell I accepted your answer, not sure what i can do more? You say marking the post as answered? How do i do that? 

REgards

Diet

[Christopher Maxwell]

@Diet Bos You're set/done - selecting an answer "does it". By marking a reply as an answer, your post/question is now categorized as being answered!

Have a great week,
Christopher