It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do I get SLA value on PowerBI desktop

I am trying to create a PowerBI report showing SLA data for issues raised in JIRA Service desk. But seems there is no field which I can use for SLA status.

1 answer

0 votes

I don't know if the "status" is exposed directly through any field, but you could eventually use Better Excel Plugin to export your ticket data, then import the XLSX file to PowerBI.

The nicety here is that you can use an Excel formula or rewrite the logic that exports the SLA values so that they produce the format you'd like to see.

This video gives a basic intro to the feature.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published Apr 03, 2019 in Marketplace Apps

How to estimate projects more accurately?

Gaining insight into your team’s effectiveness and choosing the right estimation technique.   Estimating projects is hard. It is because people have the tendency to underestimate the time thin...

271 views 2 8
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