Forum Discussion

pollyog's avatar
pollyog
Icon for Advocate I rankAdvocate I
9 years ago

JIRA 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...
Need Help
pollyog's avatar
pollyog
Icon for Advocate I rankAdvocate I
8 years ago

So, based on the last update from JIRA team:

 

https://jira.atlassian.com/browse/JRACLOUD-67570?focusedCommentId=1618137&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-1618137

 

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-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi all, 

     

    I have reported this issue on Power BI side, will update here once I get any information. 

     

    Best Regards,
    Qiuyun Yu 

    • jeremyking77's avatar
      jeremyking77
      Icon for Helper I rankHelper I
      8 years ago

      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 data

       

      let
      Source = FetchPages("", 100),

      • CraigW's avatar
        CraigW
        Frequent Visitor
        8 years ago

        Hi,

        Can you explain or link to how you would do this?

        Thanks!