How to build a custom column formula in Power query that will retrieve Image and load it to Excel to display that image from the specified column

Question

Therefore, I'm attempting to create a custom column formula that will load the image from the supplied column URL and return it. But it doesn't seem to be working.

In essence, I want the query to perform just like Excel's "=Image()" function, which pulls images from a URL. I need some assistance with this formula or question.

These are the things I've accomplished thus far.

I have added a custom column formula 

After Expanded Image, It's showing an error 

After loading the query It's showing this 

The actual result that I want 

Answer 1

Make sure ignore privacy is selected in your power query settings to fix the issue. Change both of the available options (Global and Current Workbook) to be certain. Both of these ought to be set to "Always ignore."

However, this still won't bring in binary image data from a url and I'm not sure there is a way to do so. If you already have the urls of the images, why don't you just paste those directly into Excel?