Filter doesn't work after refresh PowerPivot Data Model

[bluesky63]

Hi all PowerBI guru

whenever I refresh the tables inside PowerPivot, the corresponding pivot table created will be de-filtered, i.e. I set label to filter between two values, after refresh in the PowerPivot, I need to re-toggle it

What is the reason? is there a place to permanently fix the filtering criteria ?

https://onedrive.live.com/?cid=d249fd932335ce0e&id=d249fd932335ce0e!2301&v=photos

 

[scottsen]

Weird. and sad. Onedrive link seems to be bad, try again?

 

[TimRodman]

What version of Excel? 2010 or 2013? 32-bit or 64-bit?

 

[bluesky63]

Hi TimRodman,

Excel 2013 - 32 bit
Thanks

 

[bluesky63]

Hi scottsen

it is not an excel file but the snapshot of the filter image, see you can view in my google drive

https://drive.google.com/open?id=0BxZOzr8CB88_TGU5SDhFRWRRdzQ&authuser=0

 

[bluesky63]

I had uploaded the mock data here 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

 

[scottsen]

Been a busy lizard, but just requested access to your link.

 

[bluesky63]

http://1drv.ms/1HMOGzl

 

[scottsen]

Hrm. I couldn't consistently repro with my Excel 2013. I thought I might have saw it once. But I refreshed a variety of times w/o problem. You do get slightly different behavior out of pivot tables that have no values specified, I wonder if that is messin' you up?

 

[bluesky63]

Hi scottsen,

did you change the path in PowerPivot to your local drive ? then make some amendment to the source ? The behavior (the filter criteria is there but need to re-select) only happen when I re-open the PowerPivot, do a refresh in PowerPivot. If I leave the PP file open, goto source do some amendment and refresh in PP, the pivot table refresh is still in-tact