The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have used this exanple to also pull data from the Dovico api
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?
Solved! Go to 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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.