I have a problem on Power BI service when updating my DataFlow which retrieves some data from Jira.
Some of the data are record types and this would prevent PowerBI Service from updating the dataflow.
Here's what the error says:
Error code: Mashup Exception Expression Error Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Expression.Error: Failed to insert an array, InnerException: Sorry... We were unable to convert a value of type Record to type Text., UnderlyingError : Sorry... We were unable to convert a Record value to Text. Details: Reason = Expression.Error;ErrorCode = Lakehouse036;Message = Sorry... We were unable to convert a Record value to Text;Message.Format = Sorry... We were unable to convert a value of type #{0} to type #{1}.;Message.Parameters = {"Record", "Text"};ErrorCode = 10276;Microsoft.Data.Mashup.Error.Context = System (request ID: 5db53da9-ce10-4f11-b58e-c7872421bb86).
Here is my code:
#"Expanded get Constellation Issues" = Table.ExpandTableColumn(#"Quitar StartAT", "get Constellation Issues", {"Column1"}, {"get Constellation Issues"}),
#"Expanded Constellation Issues" = Table.ExpandRecordColumn(#"Expanded get Constellation Issues", "get Constellation Issues", {"id", "key", "fields", "changelog"}, {"ID", "ISSUE", "fields","Changelog"}),
#"Quitar ID Nulos" = Table.SelectRows(#"Expanded Constellation Issues", each ([ID] <> null)),
#"Expanded Issue" = Table.ExpandRecordColumn(#"Quitar ID Nulos", "fields", #"00-FIELDS JIRA"[id], #"00-FIELDS JIRA"[ANGLAIS]),
#"Expand Issue Type" = Table.ExpandRecordColumn(#"Expanded Issue", "Issue Type", {"id"}, {"Issue Type"}),
#"JOIN Jira Issue Type" = Table.NestedJoin(#"Expand Issue Type", {"Issue Type"}, #"JIRA ISSUE TYPES", {"id"}, "JIRA ISSUE TYPES", JoinKind.LeftOuter),
#"ADD Issue Type Name" = Table.ExpandTableColumn(#"JOIN Jira Issue Type", "JIRA ISSUE TYPES", {"FRANÇAIS"}, {"Issue Type Name"}),