Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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
jamesperry's avatar
jamesperry
Frequent Visitor
9 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.

 

bbredstang's avatar
bbredstang
Regular Visitor
8 years ago

Team,

 

Has anyone gotten this to work again using the on premise version of JIRA?  

 

I am using a copy of the content pack that was denoted in the comments here to work with on premise, and for the life of me cannot get it to return all JIRA issues for a project.

 

https://powerbi.microsoft.com/en-us/blog/explore-your-jira-data-with-power-bi/ 

 

We are on JIRA version 7.10.00

 

I do have it fetching rows however similar to the title of this thread, it only pulls the top 50.

 

Thanks in advance for any help!!

 

Brian