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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jmatuch
New Member

Loop within a loop

Hi, everyone.

 

I'm newer to Power BI, and I'm trying to mash 2 functions together to execute a loop within a loop.

  1. My first function, GetAllFolders, generates a table with 2 columns: FolderID and FolderName
  2. My second function, GetAllQueuesinFolder, generates a table with 3 columns: QueueName, OrganizationalUnitId, and ID.

What I need is for a table to be produced that takes each row of the table from GetAllFolders and loops through each row to GetAllQueuesInFolder for each folder. In the end, I want a table that has a row for each queue in all the folders. So, if each of my 4 folders has 2 queues, then I want a table with 5 columns (FolderID, FolderName, QueueName, OrganizationalUnit, and ID) and 8 rows, one for each queue.

 

Any ideas how to create this function?

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

=Table.FromRecords(List.TransformMany(Table.ToRecords(GetAllFolders(),each Table.ToRecords(GetAllQueuensinFolder([FolderName])),(x,y)=>x&y))

View solution in original post

3 REPLIES 3
wdx223_Daniel
Super User
Super User

=Table.FromRecords(List.TransformMany(Table.ToRecords(GetAllFolders(),each Table.ToRecords(GetAllQueuensinFolder([FolderName])),(x,y)=>x&y))

Thanks for your help.
I pasted your function in Power BI like so:

jmatuch_0-1702479507844.png

And clicked "Invoke" and got this error:

jmatuch_1-1702479548999.png

 

Any ideas? Thanks again.

 

EDIT:

I think I wasn't putting the function in the editor correctly. I entered it like this now, and I still got the same error as above.

jmatuch_0-1702479973854.png

 

 

 

Thanks so much for your help. I am just learning this language.

my code just a example, you need complete it in your real circumstance.

GetAllFolders() and GetAllQueuensinFolder() may have some arguements to fill.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors