Can't expand a custom field on JIRA

[MaxItaly]

Hello everyone.

What I'm trying to do is extracting a custom value created on a Jira Project.

I have downloaded the pbit, changed the "= FetchPages("", 500)" to "= FetchPages("", 100)", inserted the URL, and, following a post,

changed the fourth query "Expanded Fields" from

= Table.ExpandRecordColumn(#"Expanded Column1", "fields",
{"issuetype", "timespent", "project", "fixVersions", "customfield_10110", "customfield_10111",
 "aggregatetimespent", "resolution", "customfield_10112", "customfield_10113", "customfield_10114",
 "customfield_10104", "customfield_10105", "customfield_10106", "customfield_10107",
 "customfield_10108", "customfield_10109", "resolutiondate", "workratio", "lastViewed",
 "watches", "created", "priority", "customfield_10100", "customfield_10101", "customfield_10102",
 "customfield_10103", "labels", "timeestimate", "aggregatetimeoriginalestimate", "versions",
 "issuelinks", "assignee", "updated", "status", "components", "timeoriginalestimate",
 "description", "customfield_10006", "customfield_10009", "aggregatetimeestimate", "summary",
 "creator", "subtasks", "reporter", "customfield_10000", "aggregateprogress", "customfield_10001",
 "customfield_10004", "customfield_10115", "customfield_10116", "customfield_10117",
 "environment", "customfield_10118", "customfield_10119", "duedate", "progress", "votes",
 "parent", "customfield_10005", "customfield_10007", "customfield_10008", "customfield_10002",
 "customfield_10003"},
 {"issuetype", "timespent", "project", "fixVersions", "customfield_10110", "customfield_10111",
 "aggregatetimespent", "resolution", "customfield_10112", "customfield_10113", "customfield_10114",
 "customfield_10104", "customfield_10105", "customfield_10106", "customfield_10107", 
 "customfield_10108", "customfield_10109", "resolutiondate", "workratio", "lastViewed",
 "watches", "created", "priority", "customfield_10100", "customfield_10101", "customfield_10102",
 "customfield_10103", "labels", "timeestimate", "aggregatetimeoriginalestimate", "versions",
 "issuelinks", "assignee", "updated", "status", "components", "timeoriginalestimate",
 "description", "customfield_10006", "customfield_10009", "aggregatetimeestimate", "summary",
 "creator", "subtasks", "reporter", "customfield_10000", "aggregateprogress", "customfield_10001",
 "customfield_10004", "customfield_10115", "customfield_10116", "customfield_10117", "environment",
 "customfield_10118", "customfield_10119", "duedate", "progress", "votes", "parent",
 "customfield_10005", "customfield_10007", "customfield_10008", "customfield_10002",
 "customfield_10003"})

to

= Table.ExpandRecordColumn(#"Expanded Column1", "fields",
 {"issuetype", "timespent", "project", "fixVersions", "customfield_10110", "customfield_10111",
 "aggregatetimespent", "resolution", "customfield_10112", "customfield_10113", "customfield_10114",
 "customfield_10104", "customfield_10105", "customfield_10106", "customfield_10107",
 "customfield_10108", "customfield_10109", "resolutiondate", "workratio", "lastViewed", "watches",
 "created", "priority", "customfield_10100", "customfield_10101", "customfield_10102",
 "customfield_10103", "labels", "timeestimate", "aggregatetimeoriginalestimate", "versions",
 "issuelinks", "assignee", "updated", "status", "components", "timeoriginalestimate", "description",
 "customfield_10006", "customfield_10009", "aggregatetimeestimate", "summary", "creator", "subtasks",
 "reporter", "customfield_10000", "aggregateprogress", "customfield_10001", "customfield_10004",
 "customfield_10115", "customfield_10116", "customfield_10117", "environment", "customfield_10118",
 "customfield_10119", "duedate", "progress", "votes", "parent", "customfield_10005",
 "customfield_10007", "customfield_10008", "customfield_10002", "customfield_10003",
 "customfield_12021"},
{"issuetype", "timespent", "project", "fixVersions", "customfield_10110",
 "customfield_10111", "aggregatetimespent", "resolution", "customfield_10112", "customfield_10113",
 "customfield_10114", "customfield_10104", "customfield_10105", "customfield_10106",
 "customfield_10107", "customfield_10108", "customfield_10109", "resolutiondate", "workratio",
 "lastViewed", "watches", "created", "priority", "customfield_10100", "customfield_10101",
 "customfield_10102", "customfield_10103", "labels", "timeestimate", "aggregatetimeoriginalestimate",
 "versions", "issuelinks", "assignee", "updated", "status", "components", "timeoriginalestimate",
 "description", "customfield_10006", "customfield_10009", "aggregatetimeestimate", "summary",
 "creator", "subtasks", "reporter", "customfield_10000", "aggregateprogress", "customfield_10001",
 "customfield_10004", "customfield_10115", "customfield_10116", "customfield_10117", "environment",
 "customfield_10118", "customfield_10119", "duedate", "progress", "votes", "parent",
 "customfield_10005", "customfield_10007", "customfield_10008", "customfield_10002",
 "customfield_10003", "FieldToExtract"})

adding "customfield_12021" and "FieldToExtract" at the end, respectively.

I know for sure that some values of this field is different from "Blank" and "[Record]", but all I get to see, once ran the query, are these two values.

I thought that "[Record]" is a table that has to be expanded (it is so for other columns), but in the query editor that column cannot be expanded (and I can't find a [Record Value] either).

How do I extract that value?
What am I doing wrong?

[Anonymous]

@MaxItaly,

Could you please post a screenshot about the result that you expand the [Record] value? In addition, have you checked the blog below to add custom fields?

http://jeremykingsql.blogspot.sg/2017/08/adding-jira-custom-fields-into-power-bi.html

Regards,
Lydia

[MaxItaly · Accepted solution]

Sorry, I forgot to write that I managed to do what I wanted.

In the query editor, since you can't load more than 1000 rows, it happened that Power BI did not load a single [record] value, and because of that, I couldn't use the "Expand" button.
I pre-filtered some other columns to make sure Power BI loaded the rows with "Record" so that I could use that button.

Previously I tried to use the M syntax to expand that column, but I think I was doing something wrong since the column didn't expand.

Many thanks anyway.