Iterating through table values in M query and store the results in new table as records

[Indrasena]

I need to pass the Id values that are present in a Employee table to a web url
Below is the table

for each row in the above table the below command needs to be executed and store the result as a record

Source = Web.Contents("XXXXXXXXXXXXXXXXXXXX/employeeId="&Id, [Headers=[Authorization="Bearer "&access_token,ContentType="application/json"]]),
FormatAsJson = Json.Document(GetJson),

Note; I am able to pass only 1 id(Web.Contents("XXXXXXXXXXXXXXXXXXXX/employeeId="&Employee[Id]{0}) and unable to find something that loops and writes to a table.

[v-yiruan-msft · Accepted solution]

Hi @Indrasena ,

You can refer the content in the following links to achieve it:

Power BI Desktop Query Parameters, Part 3, List Output

Populate a Power BI parameter list using a query

1. Convert the table Employee to a list

Convert to list

2. Create a New Query Parameter and Link it to the List Query just as the one in below screenshot

Add a new parameter and link to the list

3. Filter the rows with the parameter

Filter the rows with parameter value

The below one is for Power Query online:

Multi-Value Parameters In Power Query Online

Best Regards