Importing a Star Schema source - How do I limit returned records

[briguin]

In Power BI, I'm trying to import a Star Schema source and it is a table#1 of 100% integer keys.

In order to limit the dataset I'm having to manually lookup all the key translations to user friendly names.

I want to retrieve only data for Location Key1 = 7729 . I may have a list of 100 keys to pull and do not want to manually create a M Step to filter each key.

Is the scenario below even possible:

I want to create a Table#2 that contains all the Key values I want to filter within Table#1.

Can I lookup values in Table#2 and use that within the M query to filter Table#1?

[edhans · Accepted solution]

Absolutely. I would use the List.Contains() function here. Everything in List 1 would be filtered by List 2. This is all with in a Table.SelectRows (filter) step.

I do this so often I wrote a blog post showing you each step you need to take and explained it in full detail here: Using List.Contains To Filter Dimension Tables — ehansalytics