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.
I try to make conditional extration in powery query:
Table.TransformColumns(#"Previous step", each if Text.Contains([Key], "-id") then {{"Key", each Text.BetweenDelimiters(_, "-id", " "), type text}} else null)
Error:
Expression.Error: We cannot convert a value of type Function to type List.
Details:
Value=Function
Type=Type
Solved! Go to Solution.
@MarkShu ,
Modify the code as below:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTSzUxRitWJVjIyBrIMjUwMwTwQw0QpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Key = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Key", type text}}), Result = Table.AddColumn(#"Changed Type", "New Column", each if Text.Contains([Key], "-id") then {{"Key", each Text.BetweenDelimiters(_, "-id", " "), type text}} else null) in Result
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@MarkShu ,
Modify the code as below:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTSzUxRitWJVjIyBrIMjUwMwTwQw0QpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Key = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Key", type text}}), Result = Table.AddColumn(#"Changed Type", "New Column", each if Text.Contains([Key], "-id") then {{"Key", each Text.BetweenDelimiters(_, "-id", " "), type text}} else null) in Result
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |