How to pass variables to DevAzure API calls in PowerBI

[newbiekp]

With PowerBI I have to produce some reports from Dev Azure API.

Ex: https://dev.azure.com/{organization}/{project}/_apis/build/definitions/{definitionId}?includeLatestB...

If I hardcode the values, I get the result. However I want to pass definitionID from a dropdown list (I am using a slicer) to Advanced Query , so that user can see the details for the selected build id dynamically. How can I achieve that? 

[v-kelly-msft · Accepted solution]

Hi  @newbiekp ,

Check a similar thread for help:

https://community.powerbi.com/t5/Power-Query/How-to-pass-a-value-from-one-table-iteratively-to-anoth...

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[amitchandak]

@newbiekp , This is on little bit different topic, but still deal with passing of parameter.

refer

https://medium.com/@rickychew/visualize-azure-devops-paginated-rest-api-response-with-power-bi-4ae5c...