Power BI first load excessively long/never ends

[Stephanie Hansen]

I am trying to grab sprint data from JIRA into a Power BI report via the Power BI Connector for JIRA.  

When I created my first connection, I pulled just a few tables (Issues and a few others) and that ran without issue.

Now I want to connect Sprints and IssueSprints...and it sees the tables...but just spins...for hours.

Right now....showing 8.8MB from IssueSprints

17.9MB from Issues

154KB from Sprints....

and still spinning 

Any idea how to remedy?  

[Do It]

You can use our plugin.
For the server - Microsoft Power BI Connector for Jira
For cloud - Microsoft Power BI Connector for Jira Cloud
Data export is very fast.
Our plugin has convenient data filtering. You will be able to filter your data by JQL, Date and Jira Filter.

We also made Burnup Chart, Burndown Chart, Velocity Chart, Sprint Status Report tables. With these tables, you can quickly create graphs for analyzing your sprints.
Also integrated with a large number of plugins.

For all questions, please contact support@doit-bi.com
We respond quickly

[Raza Ali Mahmood]

Do you have a connector from jira to power bi that works faster than the mentioned power bi jira connector?

[quentin_leroy]

Hello @Raza Ali Mahmood,

Quentin, Product Manager from Appfire here.

We have a solution that might be faster for you, depending on the amount of data you are planning to transfer: Power BI Connector. The solution is plug & play and free for up to 10 users. 

Do not hesitate to share your experience here, we always appreciate feedback :) 

[Raza Ali Mahmood]

Hello @quentin_leroy

I work using the following  and I am only transfering around 35-40 megabyte of data, like it toals less then 30.000 rows and maybe 20 columns. And I would not say this is a terribly large dataset. I have even went and split the queries into 7 tables so it should be around 5-6 megabyte at most.

Is there a solution that works faster?

Kind regards,
Raza

[quentin_leroy]

Hello @Raza Ali Mahmood

Do you work in a DC or Cloud environment? 

Some fields requires calculations to be made and might slow down your queries. Which fields are you querying? Have you tried running those queries during downtime hours?

The more information we have about your current environment, the better we can help to debug your integration. 

Do not hesitate to contact our support team for a personalised attention as well, they are knowledgeable and always ready to help!