Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.