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

Tushar Sawke Mar 01, 2018

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
Aron Gombas [Midori] Community Leader Mar 04, 2018

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 in Marketplace Apps & Integrations

Webinar invitation: Generate custom Jira Cloud PDF reports and exports

Jira may be a staple part of your workday, but your colleagues, customers, business partners or an auditor might need information presented in a different format, that is easy to access and read. And...

58 views 0 1
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