Read more than 100 rows from Jira into Power BI

[Anonymous]

Hello All,

I need help to connect Jira to Power Bi and it should fetch all records from Jira(more than 100)

I am able to connect but it allows only 100 rows

Thanks in Advance

[v-stephen-msft]

Hi @Anonymous ,

The connection has a 100 records limitation that occurs on the JIRA side since the JIRA content pack in Power BI Service relies on JIRA API.

You can try to load the data to SQL Server and then connect to SQL Server in Power BI.

Here is a blog about connecting Jira applications to SQL Server 2012

https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-sql-server-2012-938846858.html

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , This connector mention limitation as 100 Rows. You have App on power BI service you can check that.

You can use REST API of JIRA if needed

ore refer:https://community.atlassian.com/t5/Jira-questions/how-to-use-Microsoft-power-bi-with-jira/qaq-p/485503

[amitchandak]

@Anonymous , How you have connected to JIRA?

[Anonymous]

@amitchandak 

With the help of below article:

https://hevodata.com/learn/jira-to-power-bi/