(Dataverse) Selective Power query?

Hi,

I am new to using Dataverse and power query.

I am currently use two excel files - one for material data source and other for partlist.

So far, no trouble, but with growing number of materials.
I want to change the excel data source to Dataverse.

Background:

• Using an excel file as main material data source.
• Other excel file uses XLOOKUP to find the item code to pull item details.
• Material data is growing (so far 5,000 rows). 
• Thinking to change the data source to Dataverse.

Questions:

• I understand by creating query connection - the data needs to load into the target file then I can use XLOOKUP to query table.
• But I want it to selective - instead of all 5,000 data to be pulled into file.
• Can the power query be selective based on the item code that was used on the partlist?
  *like below image
  
  Selective powerquery?

Thank you in an advance.