Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

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

  • 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

2 Replies

  • 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's avatar
      Anonymous
      Not applicable

      Thank you Michal,

       

      It works

      I was focusing on the wrong thing,

      Thanks a lot