Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
briguin
Helper I
Helper I

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?

 

1 ACCEPTED SOLUTION
edhans
Super User
Super User

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




Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

1 REPLY 1
edhans
Super User
Super User

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




Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Solution Authors
Top Kudoed Authors