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,597
Community Members
 
Community Events
165
Community Groups

Request Type field in Power BI through Jira Power BI connector

Hi everyone,

I am trying to build a dashboard with number of tickets as per request type in power BI. I am able to see two request types in the Jira - Request type and Request Type(this is the one required in the dashboard).

jira issue.PNG

I have checked data relationship tab in the Power BI connector page but I am unable to see this field. 

If anyone has faced similar issue before, can you please share the solution. 

Thank you

2 answers

Hello @Amrit Kaur  

If you use Alpha Serve's Power BI Connector for Jira, then please contact our support team for assistance at support@alpha-serve.com

0 votes
Andy Heinzer Atlassian Team Jun 02, 2022

Hi

The request type field is a special custom field created by Jira Service Management.  Only Jira Service Management requests will have this field within the issue.  You can search for this using JQL, but you can't always do this in the Basic search like your screenshot.  Try clicking the link to "Switch to JQL" on your screenshot to get to the advanced search mode. 

From there, you should be able to find all issues that have some value for Request Type with the JQL query of

"Request Type" is not empty order by created DESC

I'm not sure how the Power BI integration works here.  But if the user account you are using in Jira does not have access to see that field type, say because it's not a licensed Jira Service Management user, or the user account does not have permissions to view those issues, that might explain why Power BI cannot see the issues you expect here.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira Service Management

Coming Soon: Insight Changing to Assets

The 2020 acquisition of Mindville added powerful asset and configuration management capabilities to Jira Service Management in the form of Insight. Following the completion of that integration, custo...

299 views 2 9
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