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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Ikeumlaut
Advocate I
Advocate I

Help: Pass a list as filter argument in Power Query

Hey,

 

I need to pass a list as a filter argument in query editor to multiple tables. I have a list of Survey Ids in an excel file and I need to pass that list to multiple tables in query editor.

 

I've tried this but I cannot get it to work.

 

Thanks!

1 ACCEPTED SOLUTION
stretcharm
Memorable Member
Memorable Member

 

Import the List.

Use a Merge each query with this using an inner join and it will remove items not in the list.

 

MergeFilter.PNG

 

 

View solution in original post

2 REPLIES 2
stretcharm
Memorable Member
Memorable Member

 

Import the List.

Use a Merge each query with this using an inner join and it will remove items not in the list.

 

MergeFilter.PNG

 

 

Worked! Thank you!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.