Loop in table and send in API

[Anonymous]

Hi

I need to get the ID from the jira_boards table, I select with red.

How can I create a Loop?

Exist foreach in Power BI?

Query:

jira_sprints

Table: jira_boards

jira_boards

[v-juanli-msft]

Hi @Anonymous 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?

If not, please feel free to let me know.

Best Regards

Maggie

[amitchandak · Accepted solution]

@Anonymous 

I think list.generate is one way refer :

https://potyarkin.ml/posts/2017/loops-in-power-query-m-language/

https://community.powerbi.com/t5/Desktop/Power-Query-M-function-LOOP/td-p/252188