The filters you're applying in the PowerPivot window only affect what is displayed, in the Power Pivot window. They don't affect what data is returned to the Data Model.
Originally Posted by
Microsoft
From
https://support.office.com/en-us/art...a-f4c823b96b5e
Filters that reduce the amount of imported data are applied only during import operations. You can’t add filters after the data is already imported and then refresh to get smaller rowsets.
Filters that control which data is displayed in Excel or in Power Pivot are easily applied at any time. Notice that filtering an existing dataset doesn’t change the data that’s in the workbook—just the data that’s displayed. So if file size is a concern, filtering the data as you import results in a smaller workbook.
In your example case, instead of loading your data directly into PowerPivot from the table, use PowerQuery to apply the filters you want, and then Load To Data Model:
Bookmarks