最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

powerquery - We were unable to convert a value of type Record to type Text - Stack Overflow

programmeradmin3浏览0评论

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"}),
发布评论

评论列表(0)

  1. 暂无评论