How to Pull JIRA Cloud data in Power Bi ?

Hi,

I've built a Jira to PBI connector and can give some info about it. From what I can tell, the "easiest" way is using Power BI's OData connector. The main issue is that the data you get from the Jira API is regular JSON. Since OData is a protocol you can't just convert the JSON data to OData, you'll need to build an OData service and create a mapping of Jira fields to OData types. This is by far the most difficult part. Jira's system fields are predictable, for example their "Created" field is a datetime field and would map to the OData type of "Edm.DateTimeOffset". The custom fields are more difficult, jira field endpoint /rest/api/3/fields gives some metadata about the field, like what type of data it will store but I haven't always found this to be accurate.

You'll also need the data from the field endpoint I mentioned above to convert the field name from the field ID that the API uses (ex: customfield_12345) to what the actual field name is (ex: Story Points). If the actual field name contains certain characters like the '#' character, then you'll have to rename these because Power BI will throw an error if column names contain this. I ran into a lot of gotchas like this, but this was for a general connector that can handle every type of field, in your case I don't think it would be as difficult, but again the OData protocol will likely be your biggest hurdle. Hopefully that provides some insight into the process!

If you have any questions feel free to reach out to me!

If you decide to go with a third party app please consider the one I built: https://marketplace.atlassian.com/apps/1238345/power-bi-connector?hosting=cloud&tab=overview

Best,
Jack