Power Query M Langage Web.Contents I get error : &amp

[Anonymous]

Hello,

My goal is to generate a power view report with images that comes from a dynamic URL path

To do that I uploaded the SQL server data base using power query

I added a column : Web.Contents("http://....&...."&[IDMASTER]&"...&...") as Binary

but I get an error message :

In this error message it repaces the url path from "&" to "&amp" but I don't know if this why it doesn't work

I've tryed with a static url : Web.Content("http://....jpg") _ same image for every line and it works

What am I doing wrong ?

Thank you in advance

[Michal_cwiok · Accepted solution]

What is the type of [IDMASTER] column? Looking at the error it seems it is a number. Please type:

Text.From([IDMASTER])

 If it does not work, I would like to have more details. Perhaps the whole Power Query code? 

Thank you

[Anonymous]

Thank you Michal,

It works

I was focusing on the wrong thing,

Thanks a lot