Reply
Frequent Visitor
Posts: 4
Registered: ‎12-30-2016

Power BI Desktop template not populating custom field values in jira

[ Edited ]

I am having issues with populating custom field values in Power BI Desktop template for jira where all the values are showing as null for custom fields.  Any help would be highly appreciated.

 

Thanks,

Haree

Established Member
Posts: 171
Registered: ‎05-27-2016

Re: Power BI Desktop template not populating custom field values in jira

Hi @hareeharan,

 

you have to provide more info.

 

Regards.

Pavel

Frequent Visitor
Posts: 4
Registered: ‎12-30-2016

Re: Power BI Desktop template not populating custom field values in jira

Hi Pavel,

 

Apologies. I am using PBI desktop template for on-premises jira. All the predefined fields are populated without any issues and the report gets generated as expected. I would also like to create some reports like sprint velocity, burndown charts and so on for which I believe you will need to use the values from the custom field columns. However, the values are showing as null for the custom fields as shown in the screenshot below. Hope this information helps.

 

Thanks,

Haree

PBIScreenshot.png

Established Member
Posts: 171
Registered: ‎05-27-2016

Re: Power BI Desktop template not populating custom field values in jira

@hareeharan unfortunately I don't have access to any Jira environment to test it. And without it I think I can't find out what is the problem.

 

But generally are these custom field columns available overall in Jira? It seems like you don't have these columns in your source, or they are not filled??

 

Regards.

Pavel

Frequent Visitor
Posts: 4
Registered: ‎12-30-2016

Re: Power BI Desktop template not populating custom field values in jira

Hi Pavel,

 

Thank you for your response. Please correct me if I am wrong. I am trying to find fields like "story points" which I am sure is in my jira issues. However, I can't find any column name called "story points" in PBI desktop template. So, I presume they must be one of the custom field names which is what I am trying to find

 

Thanks,

Haree

 

Established Member
Posts: 171
Registered: ‎05-27-2016

Re: Power BI Desktop template not populating custom field values in jira

@hareeharan as I said, unfortunately I don't have access to Jira, so I can't try it/find out what is the problem.

Maybe if there was some Jira sample project...?? I have tried to search some, but without success.

 

Regards.

Pavel

Frequent Visitor
Posts: 5
Registered: ‎11-17-2016

Re: Power BI Desktop template not populating custom field values in jira

Haree

 

Did you find the solution to your problem? I have the same issue. I see the custom fields but they have null values.

 

Thanks

Occasional Visitor
Posts: 1
Registered: ‎01-27-2017

Re: Power BI Desktop template not populating custom field values in jira

My custom jira fields are not even showing up as fields to work with in power BI. Has anybody found any documentation on Jira + Power BI? Besides the initial setup that is...

Frequent Visitor
Posts: 3
Registered: ‎03-20-2017

Re: Power BI Desktop template not populating custom field values in jira

Hi, story points can be accessed under customfield_10117

 

Where I am struggling is with custom fields I've created myself. In Jira I can see that a particular custom field ID is customfield_10300 but this is not appearing in Power BI.

 

Anyone any ideas?

 

Thanks