Forum Discussion
(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 mate...
You may filter on partlist
as
let Result = Table.SelectRows(Source, each List.Contains( Partlist[ID], [ID] )) in Result
Thank you Sergei,
If I may ask, where do I insert the above code?
If I may ask, where do I insert the above code?
In Power Query editor you may open Advanced Editor to modify M-script code, or for the concrete step you may modify the code in formula bar of the PQ editor.
Thank you SergeiBaklan ,
It is working as well 🙂
For the table name for Partlist, can it be dynamic?
As of right now, we are using the partlist excel file as teams template file that can be used by other users.
And table name tends to get messy.It could be, but it depends on which logic do you use to select this or that partlist table.
As variant that name of the file/table could be defined in the cell of Excel file which we could read by Power Query and use as parameter. Lot of samples, e.g.
Building a Parameter Table for Power Query (excelguru.ca)
- Thank you
After going through and re-create the examples on links.
It might be too difficult for other users to follow through.
However, I definitely got more understanding where to look into more.
Thank you 🙂
