Forum Discussion
Advocate IJIRA content pack bringing only few rows
Hi everyone!
I was running the JIRA content pack (https://powerbi.microsoft.com/en-us/blog/explore-your-jira-data-with-power-bi/) without any problems until today. But now I'm facing a issue that I cannot fix.
The problem is, suddenly the template started to limit the rows that are loaded from REST API. I didn't changed anything before this and I also checked if my JIRA user had some permission edition. Anybody knows what could be happening?
Thank you very much!
18 Replies
Same issue for the last couple of days now.
pollyogSeems to be a global problem :(
Probably some update on JIRA API...
Anyone had already fixed this?!?!
- pollyog
Thank you BeeEyeNoob, I'll inform here if I get some new about this.
- pollyog
**bleep**! So think we will have to wait for a feedback from them. :smileyfrustrated:
- pollyog
So, based on the last update from JIRA team:
The problem is not considered as a bug and they recommend to use pagination. The problem is, if you are using the JIRA content pack, it is already using pagination (look for GenerateByPages function), but it stopped to work after this update.
Anyone could find a way to "fix" it?
Thanks!
v-qiuyu-msftCommunity Support
Hi all,
I have reported this issue on Power BI side, will update here once I get any information.
Best Regards,
Qiuyun Yu
jeremyking77Helper I
I found that if you edit the data source in the advanced editor (using Power BI Desktop)
the second line which you can change to 100. Now that JIRA has restricted to 100 rows you can just loop on the 100 each time instead. For those that don't know.. the value 100 is referring to the pagesize that it gets when it loops through the datalet
Source = FetchPages("", 100),
antonstorozhukHelper V
Hello pollyog
I’d like to propose and alternative solution for you, you might want to try out our app - Power BI Connector for Jira: https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=cloud&tab=overview it's available for Jira Cloud / Server / Data Center.
We have a handy User/Admin Guide https://aserve.atlassian.net/wiki/spaces/PBCFJC/overview and fast/responsive support team at [email protected]. Please let us know if you need any assistance.
Cheers!
Anton
===
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
