Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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
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
User | Count |
---|---|
5 | |
5 | |
3 | |
2 | |
2 |
User | Count |
---|---|
10 | |
7 | |
5 | |
4 | |
4 |