Power Query M: For each Loop

[istduncan-cohp]

Hello.

I am somehwat familar with the Power Query M Language, but need a little  help.  I am pulling some data from the Microsoft Graph API.  I want to take the data retireved from List User and create a funtion to build another query that will pull the users profile photo for each user I have pulled from List of User.  If I can Get a better understanding on how to do something similiar to a foreach loop, this could possibly help in help me with the odata.nextLink Pagination function I am currently working on.  

[lbendlin · Accepted solution]

Convert that list of users into a table.  Add a column to a table that calls the photo function (you will need to Base64 encode the result).

That's it - that's how Power Query does "For each" things.

[istduncan-cohp]

@lbendlin Are you referring to BinaryEncoding.Base64?

[lbendlin]

If you want to use these pictures in Power BI visuals, yes.