Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,667
Community Members
 
Community Events
165
Community Groups

Jira Align to Power BI connection

How do I connect Jira Align with PowerBI. I tried using the JA Rest Api but failing during authentication. Has anyone integrated PowerBI and Jira Align before? If yes, Can you provide insights on authentication?

2 answers

2 votes

Hello Raja!

There's no way to connect directly to the cloud Jira Align database, but it's possible via Enterprise Insights (formerly Leo BI). 

Enterprise Insights (EI) is an add-on service to Jira Align which enables access to a relational view of the customer’s data. The EI database is effectively a data mart for Jira Align.

You can ask your TAM or EA for more details about this add-on.

 

If you already have Enterprise Insights, you can follow the guide below for SQL users' login (For Azure AD, you should use a different authentication type).

https://community.atlassian.com/t5/Jira-Align-articles/Connecting-to-Jira-Align-Enterprise-Insights-with-SQL/ba-p/2008723

1 vote
Rich Sparks Atlassian Team Jun 06, 2022

If you are going to use PowerBI for reporting, you should use the Enterprise Insights database. The Rest APIs aren't appropriate for the kind of reporting typically done through PowerBI or other reporting tools.

You can see this article here about connecting PowerBI to Enterprise Insights. 

https://community.atlassian.com/t5/Jira-Align-articles/Connecting-to-Jira-Align-Enterprise-Insights-with-SQL/ba-p/2008723

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Align

Rockin' the Roadmap - How to make most of the Roadmap with Jira Align

The roadmap challenge for large scale agile enterprises Regardless of the agile framework you use, the agile enterprise has a massive scale with the challenge to connect hundreds of teams and thous...

2,591 views 7 26
Read article

Community Events

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

Events near you