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.
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?
Solved! Go to Solution.
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 @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.
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |