PBI Query Parameters

[farhandsome]

Hi all,

I am a newbie to Query Parameters and wanted to know if this was possible and the simplest way to do this. 

I have a data source from Excel in my PBI Desktop. Let's say, for example, there is a column denoted "Column A" in this dataset. 

I have another data source extracted from the latest .xlsx file in a folder (I've already established the code for this), but I'd like to filter the data pulled based on Column A in the other table. 

I would like to set up a parameter to only pull in a row from this data source if that row has a value in a specific column that matches one of the values in Column A.

Here's a visual of what I mean:

Data Source #1:

ID	Material	Qty
12345	AAA	5
67891	ABC	10
13579	BBB	1
24680	CDE	3
00000	CCC	5

All of this data will be loaded in the PBI Desktop.

Data Source #2

Routing Time	Material
50	AAA
60	XYZ
40	BBB
10	SUV
20	LMN

The strikethrough values are NOT loaded into the table becauses the "Material" column does not match any value that is in the "Material" column of Data Source #1. How do I go about setting up this parameter?

Thanks,

Farhan

[artemus · Accepted solution]

You can do this using Merge queries. Choose the two tables, along with their matching queries. Then choose the join type as Semi, which will only keep rows from the first that match the second.