Power BI first load excessively long/never ends

Question

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?

quentin.leroy · Answer

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!

Raza Ali Mahmood · Answer

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 · Answer

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 :)