Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
fergalom
Frequent Visitor

Nested List.generate

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?

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-qiuyu-msft
Community Support
Community Support

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Kudoed Authors