Forum Discussion
Importing a Star Schema source - How do I limit returned records
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?
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
1 Reply
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