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.

​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 imageSelective powerquery?Thank you in an advance.  Read More

​