Forum Discussion
Inner Join Direct Query in the Model
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.
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.
