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,
I am building a Custom Connector to get data from a web sevrice. There are instances where the data would be null. Is tehre any error handling mechanism where it if it runs into an error, it can skip it and move on. Like Try catch?
@Stharwani wrote:
Hello,
I am building a Custom Connector to get data from a web sevrice. There are instances where the data would be null. Is tehre any error handling mechanism where it if it runs into an error, it can skip it and move on. Like Try catch?
I'm not a M master, but based on my test, there's some error handling mechanism in M, at least the "try" word works some way. The M code below processes to last step though there's error midway.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlSK1YlWSgKTyUqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), //change the type of an non-existing column #"Changed Type1" = try Table.TransformColumnTypes(#"Changed Type",{{"addAnewCol", Int64.Type}}), #"Final result" = #"Changed Type" in #"Final result"
Could you be more specifc on your scenario, what kind of web service? I think you might add a check null step.
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 |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
23 | |
3 | |
2 | |
2 | |
2 |