URL validation

Hi philippelinder,

I have found a way could help your indicate if the the URL is valid, you could have a try with the query below.

Here is my test data source. You could copy and paste it in Advanced Editor in Qury Editor.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fY/LDoIwFET/hbXlXgiocenObyCkqeWGFukjbUU+XwWNC6PrmXMy0zSZSsnHA0CFVUwuUC6dgRKLPWANuIOjDl1kJyN6ygffZ+3mwyga/ZyLzp1XTDqbyCbohFkyIAsPqbyAcjeWHEw6XsXIAk0UIjH9tLJIIkgFfJCBvw1GaMu8CBGWzj+QTSUvEHGut/i18PXqx6m13t4B", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [URL = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"URL", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each try Binary.Length(Binary.From(Web.Contents([URL]))) >0 otherwise false)
in
    #"Added Custom"

We could add a custom column to indicate if a URL will not work by tracing the binary of the url. However, the performance will not good if we in the way, because it will trace each url for some time.

More details, you could refer to my attachment.

Best Regards,

Cherry