Insufficient Entity Relationship Diagram for Service Management tables

[Kaptani Nataly-Rose]

Hi everyone,

We’ve been using the Power BI Connector for Jira for the past couple of months, and it has generally worked well. However, I’m currently trying to create a report using only data from Jira Service Management and have run into an issue.

I’ve noticed that some tables, such as Request Types and Request Portal Groups, don’t seem to include issue-related data, which prevents me from linking them with other tables. Interestingly, when I search for tickets directly, this information is visible at the issue level.

Could this behaviour be related to permissions, or is this a known issue that’s being addressed?

Any insights would be greatly appreciated!

[Salih Tuç]

Hi @Kaptani Nataly-Rose ,

I didn't get the full picture that you try to access but not sure you can get these values directly from the issues since it uses additional APIs.

However, you may try to use project information for joining. If the issue/ticket's project's type is "Service project" then it is a JSM ticket.