Forum Discussion
URL validation
Hi everyone
I have a list with Picture URL. The Images are displayd perfectly. But what IWould like to get is a formula to indicate if a URL will not work. This way I could get a list with missing images.
any Ideas or suggestions?
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
2 Replies
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
Hi is there a way to do this for dax fucntion, emcompassing mulitple URL links.
