Connect Jira Service Management to MS Fabric for reporting

[Bruno Macedo]

Hi everyone,

I’m looking to connect Microsoft Fabric OneLake to our Jira instance, which is hosted on a aws data center (not cloud), to create the basis for crossed applicattion poewrbi reports. I would appreciate any guidance on the steps required to establish this connection.

Specifically, I need to know:

1. How to extract data from Jira and store it in Microsoft Fabric OneLake.
2. The best practices for setting up this data pipeline.
3. Any tools or connectors that can facilitate this process.
4. How to automate the data extraction and loading process.
5. Any potential challenges or considerations when working with a data center-hosted Jira instance.

Thank you in advance for your help!

[Marc - Devoteam]

Hi @Bruno Macedo 

This might help you.

I found this in an article on a MS forum.

"First, extract the Jira data.

Use Microsoft Fabric's Data Pipelines to connect to the Jira API and extract data. While there is currently no direct Jira connector for Fabric Data Pipelines, you can connect using the REST API.

REST APIs for Fabric Data Factory pipelines now available | Microsoft Fabric Blog | Microsoft Fabric

Solved: Connection to Jira Cloud with Fabric and Data Pipe... - Microsoft Fabric Community

Use Microsoft Fabric's Data Lake Storage to store the extracted data.

Convert and load Data from Data Lake Storage to a Data Warehouse using Microsoft Fabric's Data Warehouse feature. You can use Data Pipelines to automate this process."

[Bruno Macedo]

Thank you Marc. I think the APIs would take like 18 hours to get the 100s of thousands of tickets, but i will take a look.