Forum Discussion
Using local images in matrix column -- String Larger than Page Size
Update: I tried the function on other pictures and it seemed to work as expected. I noticed that the .jpegs that it worked with were much smaller than the pictures that it didn't work with, so I got the pictures under about 20 kb each and it's now working perfectly! I guess the length of the URL string is directly correlated with how big the file is.
v-lili6-msft Sorry, to be clear, I was using the Sort by Column. Each picture has a name "Tommy.jpeg", "Lisa.jpeg", and also has the local URL column called BinarytoPbiImage, which I've placed in the "Column" field of the matrix visual. Whenever I try ordering BinarytoPbiImage by name, I get the error. I attempted what you said and tried using an Index column (numbered it in alphabetical order starting from one) but I ended up getting the same error. :(
Update: I tried the function on other pictures and it seemed to work as expected. I noticed that the .jpegs that it worked with were much smaller than the pictures that it didn't work with, so I got the pictures under about 20 kb each and it's now working perfectly! I guess the length of the URL string is directly correlated with how big the file is.