Forum Discussion

pollyog's avatar
pollyog
Icon for Advocate I rankAdvocate I
8 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
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!

  • jamesperry's avatar
    jamesperry
    Frequent Visitor
    8 years ago

    To get PowerBi desktop to open Jira issues download and open the pbix file here

    https://onedrive.live.com/?authkey=%21AH4_6OHXy6siE74&cid=E7E2C1CD5556023F&id=E7E2C1CD5556023F%21116639&parId=E7E2C1CD5556023F%21116638&action=locate 

     

    Click the data view in the left pane

    Click the edit queries button and select edit queries

     

    In the right pane you'll see a list of steps taken

    Click on the top one that says Source

    Change the value that appears in the formula bar to

    = FetchPages("", 100)

     

    I hope someone updates the Mircrosoft PowerBI service so that it starts working again soon as the desktop version requires manual refresh if you're publishing to the service.

     

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      8 years ago

      Hi all, 

       

      We got response from PG team below: 

       

      We will need to change the content pack design to accommodate for this change and we haven’t been able to get to that work item yet due to other high priority item.

       

      Best Regards,
      Qiuyun Yu 

    • davidbyrne1's avatar
      davidbyrne1
      New Member
      8 years ago

      Hi, thanks for the info - but I can't seem to get this working.  In what area are you entering the formula? 

       

      Thanks,

      Dave,

    • davidbyrne1's avatar
      davidbyrne1
      New Member
      8 years ago

      Hi, thanks for the info - but I can't seem to get this working.  In what area are you entering the formula? 

       

      Thanks,

      Dave,

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        @davidbyrne1 in the advanced editor of the get data page.