Forum Discussion
Iterating through table values in M query and store the results in new table as records
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.
- Anonymous4 years ago
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
1 Reply
- AnonymousNot applicable
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