Nested List.generate

[fergalom]

I have used this exanple to also pull data from the Dovico api

https://community.powerbi.com/t5/Integrations-with-Files-and/how-to-create-a-query-that-paginates/m-...

While trying to get expense details from the api, I get a table with various info I need but also a further onward URI which points to some of the expense sheet details I also need

Relevant Dovico Api info

http://apideveloper.dovico.com/Expense+Entries#Get all Expense Sheets

URI example in a expense table column:

https://api.dovico.com/ExpenseEntries/Sheet/{SheetID}/?version=5

Is it possible to do a nested list.generate in order to also extract this further data from the Expense sheet?

ANy code examples I could refer to?

[v-qiuyu-msft · Accepted solution]

Hi @fergalom,

You can refer to this blog to do nested List.Generate: Nested Loop with List.Generate in Power Query.

Best Regards,
Qiuyun Yu