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

0 votes

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 enter image description here

After Expanded Image, It's showing an error enter image description here

After loading the query It's showing this enter image description here

The actual result that I want enter image description here

Feb 5, 2023 in Others by Kithuzzz
• 38,000 points
1,206 views

1 answer to this question.

0 votes

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."

enter image description here

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?

answered Feb 5, 2023 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

How do you populate a google sheets/excel column with cells from a column in another sheet in the same document?

You have two options on chronology: sheet-by-sheet =QUERY({Sheet1!X:Z; Sheet2!X:Z; ...READ MORE

answered Dec 19, 2022 in Others by narikkadan
• 63,600 points
1,618 views
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

answered Jan 9, 2023 in Others by narikkadan
• 63,600 points
674 views
0 votes
1 answer

How can I scrape a excel file from a website and divide it in different parts?

Use Scrapy or beautifulsoup4 parsing data it's more convenient ...READ MORE

answered Jan 13, 2023 in Others by narikkadan
• 63,600 points
675 views
0 votes
1 answer

How to split text values by a delimiter?

The Split function is what you are looking for: =Split(A1, ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
• 63,600 points
706 views
0 votes
1 answer

Power query to return true / false if multiple columns are either = or null

Add column, custom column with formula: = try ...READ MORE

answered Feb 3, 2023 in Others by narikkadan
• 63,600 points
2,316 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
4,274 views
0 votes
1 answer

Power Query : http POST request with form data

Try using Uri.BuildQueryString and Json.Document. let ...READ MORE

answered Dec 12, 2018 in Power BI by Upasana
• 8,620 points
8,810 views
0 votes
1 answer

How to unmerge multiple cells and transpose each value into a new column in Pandas dataframe from excel file

Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE

answered Jan 8, 2023 in Others by narikkadan
• 63,600 points
2,569 views
0 votes
1 answer

How to insert a new row in the specified cell only, of Excel sheet using c#?

I have this worksheet with a matrix ...READ MORE

answered Nov 24, 2022 in Others by narikkadan
• 63,600 points
2,353 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP