Please help clean Jira connector code

Hi everyone!

We've got Jira Service Management Cloud and Power BI Desktop with a connector. Currently I need to add one more column with Reaction SLA by Hour. The issue is: the data is in JSON format so duplicating the column with the same parent data fileds lead to an error: data can be accessed via Editor but is not avalable from the application.

Feedback Type:
Frown (Error)

Error Message:
An error occurred while rendering the report.

Stack Trace:
Microsoft.PowerBI.Client.Windows.JavaScriptException
Error: [ngRepeat:dupes] Duplicates in a repeater are not allowed. Use 'track by' expression to specify unique keys. Repeater: prop in $ctrl.viewModel.properties | filter:$ctrl.filterProperties, Duplicate key: object:261, Duplicate value: {"hasCheckedChildren":false,"contract":{"displayName":"Resolution breach Hour","name":"Resolution breach Hour","type":{"underlyingType":260,"category":null},"column":{"defaultAggregate":2,"variations":[]},"kind":0,"format":"0","canDelete":true},"schema":{"entities":[{"name":"Jira-Issues","displayName":"Jira-Issues","visibility":0,"properties":

I've got little knowledge in M so I can't understand how to fix the code. Please help me clean the code:

let
    Issues = let
    Issues = let
    Source = JiraData,
    #"Expanded fields" = Table.ExpandRecordColumn(Source, "fields", Text.Split(FieldsToGet,",")),
    #"Expanded assignee" = Table.ExpandRecordColumn(#"Expanded fields", "assignee", {"displayName"}, {"Assignee"}),
    #"Expanded reporter" = Table.ExpandRecordColumn(#"Expanded assignee", "reporter", {"displayName"}, {"Reporter"}),
    #"Replace null assignee" = Table.TransformColumns(#"Expanded reporter", {"Assignee", each if _ is null then "Unassigned" else _}),
    #"Expanded project" = Table.ExpandRecordColumn(#"Replace null assignee", "project", {"key", "name"}, {"Project", "Project Name"}),
    #"Transform project name" = Table.ReplaceValue(#"Expanded project", each [Project Name], each [Project Name] & " (" & [Project] & ")", Replacer.ReplaceText, {"Project Name"}),
    #"Expanded priority" = Table.ExpandRecordColumn(#"Transform project name", "priority", {"name", "id", "iconUrl"}, {"Priority", "Priority Id", "Priority Icon URL"}),
    #"Expanded issuetype" = Table.ExpandRecordColumn(#"Expanded priority", "issuetype", {"name", "subtask"}, {"Issue Type", "Is Subtask"}),
    #"Expanded status" = Table.ExpandRecordColumn(#"Expanded issuetype", "status", {"name", "id", "iconUrl"}, {"Status", "Status Id", "Status Icon URL"}),
    #"Expanded resolution" = Table.ExpandRecordColumn(#"Expanded status", "resolution", {"name"}, {"Resolution"}),
    #"Expanded components" = Table.ExpandListColumn(#"Expanded resolution", "components"),
    #"Expanded components1" = Table.ExpandRecordColumn(#"Expanded components", "components", {"name"}, {"Components"}),
    #"Replace null resolution" = Table.TransformColumns(#"Expanded components1", {"Resolution", each if _ is null then "Unresolved" else _}),
    #"Changed Type" = Table.TransformColumnTypes(#"Replace null resolution",{{"created", type datetimezone}, {"updated", type datetimezone}, {"resolutiondate", type datetimezone}, {"id", Int64.Type}, {"Priority Id", Int64.Type}}),
    #"Add hour created" = Table.AddColumn(#"Changed Type", "Hour created", each Time.Hour([created]), Int64.Type),
    #"Add date created" = Table.AddColumn(#"Add hour created", "Date Created", each Date.From([created]), type date),
    #"Add week created" = Table.AddColumn(#"Add date created", "Week Created", each Date.EndOfWeek([Date Created]), type date),
    #"Add date updated" = Table.AddColumn(#"Add week created", "Date Updated", each Date.From([updated]), type date),
    #"Add week updated" = Table.AddColumn(#"Add date updated", "Week Updated", each Date.EndOfWeek([Date Updated]), type date),
    #"Add date resolved" = Table.AddColumn(#"Add week updated", "Date Resolved", each Date.From([resolutiondate]), type date),
    #"Add week resolution" = Table.AddColumn(#"Add date resolved", "Week Resolved", each Date.EndOfWeek([Date Resolved]), type date),
    #"Add Is Resolved" = Table.AddColumn(#"Add week resolution", "Is Resolved", each if [Date Resolved] <> null or List.Contains({"Cancelled","Closed","Done"}, [Status]) then 1 else 0, Int32.Type),
    #"Add Resolution Status" = Table.AddColumn(#"Add Is Resolved", "Resolution Status", each if [Is Resolved] = 1 then "Resolved" else "Unresolved", type text),
    #"Removed columns" = Table.RemoveColumns(#"Add Resolution Status", {"expand","Meta","Timestamp","created","updated","resolutiondate"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed columns",{{"id", "Issue Id"}, {"key", "Issue Key"}, {"self", "Issue URL"}, {"summary", "Summary"}}),
    #"Transform issue URL" = Table.ReplaceValue(#"Renamed Columns", each [Issue URL], each JiraURL & "/browse/" & [Issue Key], Replacer.ReplaceText, {"Issue URL"})
in
    #"Transform issue URL",
    #"Expanded customfield_10103" = Table.ExpandRecordColumn(Issues, "customfield_10103", {"value"}, {"MCS Service"}),
    #"Renamed Columns" = Table.RenameColumns(#"Expanded customfield_10103",{{"customfield_10101", "Resource ID"}, {"customfield_10105", "Request channel"}, {"customfield_10024", "Satisfaction"}, {"customfield_10099", "MCS Project"}, {"customfield_10002", "Organization"}}),
    #"Expanded Organization" = Table.ExpandListColumn(#"Renamed Columns", "Organization"),
    #"Expanded Organization1" = Table.ExpandRecordColumn(#"Expanded Organization", "Organization", {"name"}, {"name"}),
    #"Renamed Columns1" = Table.RenameColumns(#"Expanded Organization1",{{"name", "Organization"}}),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns1", each true),
    #"Duplicate SLA Reaction" = Table.DuplicateColumn(#"Filtered Rows", "customfield_10038", "SLA Reaction Hour"),
    #"Renamed Columns2" = Table.RenameColumns(#"Duplicate SLA Reaction",{{"customfield_10038", "Reaction"}}),
    #"Expanded Reaction" = Table.ExpandRecordColumn(#"Renamed Columns2", "Reaction", {"completedCycles"}, {"breached"})
in
    #"Renamed Columns2",
    #"Expanded Reaction" = Table.ExpandRecordColumn(Issues, "Reaction", {"completedCycles"}, {"completedCycles"}),
    #"Expanded completedCycles" = Table.ExpandListColumn(#"Expanded Reaction", "completedCycles"),
    #"Expanded completedCycles1" = Table.ExpandRecordColumn(#"Expanded completedCycles", "completedCycles", {"breached"}, {"breached"}),
    #"Expanded Request channel" = Table.ExpandRecordColumn(#"Expanded completedCycles1", "Request channel", {"value"}, {"value"}),
    #"Renamed Columns" = Table.RenameColumns(#"Expanded Request channel",{{"breached", "SLA Reaction"}, {"value", "Request channel"}}),
    #"Duplicate SLA Resolution" = Table.DuplicateColumn(#"Renamed Columns", "customfield_10037", "SLA Resolution Hour"),
    #"Expanded SLA Resolution Hour" = Table.ExpandRecordColumn(#"Duplicate SLA Resolution", "SLA Resolution Hour", {"id", "name", "_links", "completedCycles", "ongoingCycle"}),
    #"Expanded customfield_10037" = Table.ExpandRecordColumn(#"Duplicate SLA Resolution", "customfield_10037", {"completedCycles"}, {"completedCycles"}),
    #"Expanded completedCycles2" = Table.ExpandListColumn(#"Expanded customfield_10037", "completedCycles"),
    #"Expanded completedCycles3" = Table.ExpandRecordColumn(#"Expanded completedCycles2", "completedCycles", {"breached"}, {"breached"}),
    #"Renamed Columns1" = Table.RenameColumns(#"Expanded completedCycles3",{{"breached", "SLA Resolution"}}),
    #"Removed Columns" = Table.RemoveColumns(#"Renamed Columns1",{"Status Id", "Status Icon URL", "Priority Id", "Priority Icon URL"}),
    #"Expanded issuelinks" = Table.ExpandListColumn(#"Removed Columns", "issuelinks"),
    #"Duplicated Column" = Table.DuplicateColumn(#"Expanded issuelinks", "issuelinks", "issuelinks - Copy"),
    #"Expanded issuelinks1" = Table.ExpandRecordColumn(#"Duplicated Column", "issuelinks", {"outwardIssue"}, {"outwardIssue"}),
    #"Expanded outwardIssue" = Table.ExpandRecordColumn(#"Expanded issuelinks1", "outwardIssue", {"key"}, {"key"}),
    #"Renamed Columns2" = Table.RenameColumns(#"Expanded outwardIssue",{{"key", "LinkedIssue"}}),
    #"Expanded issuelinks - Copy" = Table.ExpandRecordColumn(#"Renamed Columns2", "issuelinks - Copy", {"type"}, {"type"}),
    #"Expanded type" = Table.ExpandRecordColumn(#"Expanded issuelinks - Copy", "type", {"outward"}, {"outward"}),
    #"Renamed Columns3" = Table.RenameColumns(#"Expanded type",{{"outward", "LinkedType"}}),
    #"Add Is Escalated" = Table.AddColumn(#"Renamed Columns3", "Is Escalated", each if [LinkedType] = "causes" then 1 else 0, Int32.Type),
    #"Expanded customfield_10061" = Table.ExpandRecordColumn(#"Add Is Escalated", "customfield_10061", {"value"}, {"value"}),
    #"Renamed Columns4" = Table.RenameColumns(#"Expanded customfield_10061",{{"value", "Alert Component"}}),
    #"Expanded customfield_10060" = Table.ExpandRecordColumn(#"Renamed Columns4", "customfield_10060", {"value"}, {"value"}),
    #"Renamed Columns5" = Table.RenameColumns(#"Expanded customfield_10060",{{"value", "Alert Reason"}}),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns5", each Date.IsInCurrentYear([Date Created])),
    #"Expanded SLA Resolution Hour1" = Table.ExpandRecordColumn(#"Filtered Rows", "SLA Resolution Hour", {"ongoingCycle"}, {"ongoingCycle"}),
    #"Expanded ongoingCycle" = Table.ExpandRecordColumn(#"Expanded SLA Resolution Hour1", "ongoingCycle", {"breachTime"}, {"breachTime"}),
    #"Expanded breachTime" = Table.ExpandRecordColumn(#"Expanded ongoingCycle", "breachTime", {"iso8601"}, {"iso8601"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded breachTime",{{"iso8601", type datetimezone}}),
    #"Extracted Hour" = Table.TransformColumns(#"Changed Type",{{"iso8601", Time.Hour, Int64.Type}}),
    #"Renamed Columns6" = Table.RenameColumns(#"Extracted Hour",{{"iso8601", "Resolution breach Hour"}}),
    #"Expanded SLA Reaction Hour" = Table.ExpandRecordColumn(#"Renamed Columns6", "SLA Reaction Hour", {"completedCycles"}, {"completedCycles"}),
    #"Expanded completedCycles4" = Table.ExpandListColumn(#"Expanded SLA Reaction Hour", "completedCycles"),
    #"Expanded completedCycles5" = Table.ExpandRecordColumn(#"Expanded completedCycles4", "completedCycles", {"stopTime"}, {"stopTime"}),
    #"Expanded stopTime" = Table.ExpandRecordColumn(#"Expanded completedCycles5", "stopTime", {"iso8601"}, {"iso8601"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Expanded stopTime",{{"iso8601", type datetimezone}}),
    #"Extracted SLA Resolution Hour" = Table.TransformColumns(#"Changed Type1",{{"iso8601", Time.Hour, Int64.Type}}),
    #"Renamed Columns7" = Table.RenameColumns(#"Extracted SLA Resolution Hour",{{"iso8601", "Reaction breach Hour"}})
in
    #"Renamed Columns7"