Connect Jira to Quick Sight

Greetings everyone, I’m looking to showcase all Jira issues with their respective fields in Quick Sight for visualization purposes. When selecting the Jira dataset option in Quick Sight, which URL should I choose? I randomly selected one, but it only gave me the option to choose between issues and projects, and the dataset import failed. I’m uncertain about the process; could you please provide guidance?
quicksight #jira data-source

Hi thucanh, welcome to the community!

Can you explain more on “which URL should I choose”. You need to select Site base URL (i.e. https://xxxx.atlassian.net/) And what do you wanna see in the data?

Hi @imaitri,
Screen Shot 2024-03-28 at 11.34.04 AM

I’m aiming to extract fundamental information from tickets, including title, description, current status, timeline, assigned person, etc. However, I’m uncertain about the correct JIRA link to input for this purpose.

Hi @thucanh

you can create JIRA connection with site base URL ( https://xxxx.atlassian.net/) and include API token as well.

Please create the API token in atlassian under Manage Account – Security – API Tokens – Create and Manage API Tokens

Once the datasource is created you will be able to access JIRA issues and create Quick Sight dataset to analyze it further. And please note currently Quick Sight JIRA connector supports only standard fields .

Thanks
VInod

So, custom fields we include in JIRA won’t appear in Quick Sight? Is there a solution for this, given we require numerous custom fields?

Hello @thucanh , @apjvinod , and @imaitri !

@thucanh are you still facing this issue or were you able to find a solution?

You could try the solution below: