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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rayishome
Resolver I
Resolver I

Inner Join Direct Query in the Model

Setting up a model that will work with Analyze in Excel etc does not seem to honor any type of filter where a Inner Join should be used.  For example if filtering a Date Table to a range of date then in the model joining hte date table to a log table the expected results should include only log entries from the dates within the range within the Date Table. 

 

Is there a way to force the model to perform an inner join? 

2 REPLIES 2

Hi @rayishome

Where do you perform a filter? in Excel's data model? then it shouldnt work . Filters in data model, i.e. inside Power Pivot, just show you filtered rows, but do not apply any actual filters on data.

If you perform filter in pivot tables, or via slicers, then they shall work, filtering linked tables as well.

Maxim Zelensky
excel-inside.pro

What I'm looking for is to create a dataset that joins two tables and while joining the tables in the Relationships it does a inner join.  This way one table will filter the other based on the filters applied in the Querie.   It looks like when you build relationships it's always a left join...  I tried Merge to join the two tables using an inner join but it seems to pull all the data from both tables into memory then perform the join.  This would work with Excel of some small dataset, but not a huge table. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.