Filter doesn't work after refresh PowerPivot Data Model

[bluesky63]

For illustration, I had attached mock data both Excel source and Excel PowerPivot to simulate my issue

TeleList_source.xlsx :- User will update whenever they created EMPID

Telelist_PowerPivot.xls :- IT team will pick up the Pivot_Table created from PowerPivot Data model (which link to Telelists_source.xlsx)


in the Pivot_table, I had set label filter to be > 9999

try the simulation, goto Telelist_powerPivot.xls (please change the path), do a refresh in the PowerPivot (A_Ong changed to Alex_Ong), you will notice that the pivot table filter no long working, i.e. all the non-create ID (number) is listed.

I have to goto label filter and re-select it, in order to show only those EMP_ID that created

Note :- I am using Office 2013