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
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!

    • 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