Forum Discussion

Revokez's avatar
Revokez
Frequent Visitor
6 years ago
Solved

Filtering by whether Image Exists or Not

Hi   I've got a table of data that includes a column that pulls in an image URL using the Data Category: Image URL. However some of these images exist and some of these images don't exist. This mea...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Revokez ,

     

    We can add a custom in power query editor to identify if this url is valid:

     

    let 
ContentType = Binary.InferContentType(Web.Contents([Address]))[Content.Type],
t = Table.RemoveRowsWithErrors(#table({"Type"} ,{{if Text.Contains(ContentType,"image") then 1 else null}} )),
RemoveNull = Table.SelectRows(t,each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))
in
not Table.IsEmpty(RemoveNull)

     

     

    Then you can use it in any filter you want.

     

     

    If you are using the local file address, try to use the File.Content instead of Web.Content


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Revokez ,

 

We can add a custom in power query editor to identify if this url is valid:

 

let 
ContentType = Binary.InferContentType(Web.Contents([Address]))[Content.Type],
t = Table.RemoveRowsWithErrors(#table({"Type"} ,{{if Text.Contains(ContentType,"image") then 1 else null}} )),
RemoveNull = Table.SelectRows(t,each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null})))
in
not Table.IsEmpty(RemoveNull)

 

 

Then you can use it in any filter you want.

 

 

If you are using the local file address, try to use the File.Content instead of Web.Content


Best regards,

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for providing a solution for this issue.  I have successfully added the column, but all of my URLs evaluate as false.  Whether the image exists or not.

 

An image that should be false, 

https://interfaceinc.scene7.com/is/image/InterfaceInc/7404004999G35S001_custom_custom-242847-029_va1?$160x160$

 

An image that should be true,

https://interfaceinc.scene7.com/is/image/InterfaceInc/1151006999G15S001_cubic_area_va1?$160x160$

 

Can you help me figure out what might be wrong with my code.  I used your exact code.  Why isn't it working?

 

Thanks in advance!