Photo linked with Google Drive not able to show

Your photos need to have publicly accessible URLs.

See this topic for more about that: Photo links from google sheets are not displayed in data viewer list