This video describes how to unzip and extract file contents to Power BI. Reading zip files without extracting them.
Link to Mark's Blog: https://sql10.blogspot.com/2016/06/reading-zip-files-in-powerquery-m.html
This video describes how to display a default image when there is no data present for the image URL in Power BI.