Exclude rows at powerpivot table

[2avrham]

Hi all,

I have PowerPivot table that using local file as data source, this file I replace often according to my choice.

my problem is that after I generate my file it appears like this:


"
txtSelectedTimeSpan textbox8
Site: HVC Tester Type: CMT ,OLB ,Verigy

textbox12 textbox15 textbox21 textbox24 textbox30 textbox33 textbox36 textbox45 textbox46 textbox47 textbox48 textbox49
HVC CMT 93.75 76.84% 15.75 12.91% 4.5 3.69% 8 6.56% 0 0.00%
HVC Verigy 34.5 28.28% 43.75 35.86% 43.75 35.86% 0 0.00% 0 0.00%

textbox44 textbox4 textbox6 textbox11 textbox14 textbox17 textbox20 textbox23 textbox26 textbox29 textbox32 textbox35
CMT CMT0263 39.25 64.34% 10.5 17.21% 3.25 5.33% 8 13.11% 0 0.00%
CMT CMT0371 54.5 89.34% 5.25 8.61% 1.25 2.05% 0 0.00% 0 0.00%
Verigy ilv93k33 10.75 17.62% 38.5 63.11% 11.75 19.26% 0 0.00% 0 0.00%
Verigy ilv93k34 23.75 38.93% 5.25 8.61% 32 52.46% 0 0.00% 0 0.00%

textbox69 textbox70 textbox71 textbox72 textbox73 textbox74 textbox76
Feb 24 2015 1:00AM CMT CMT0263 UNDEFINED Down
Feb 24 2015 1:00AM Verigy ilv93k33 UNDEFINED Logged Out
Feb 24 2015 1:00AM DBELKIN Verigy ilv93k34 UNDEFINED Active
Feb 24 2015 1:00AM GDLUSER CMT CMT0371 alpineridge Tester Maintenance Active
Feb 24 2015 1:15AM CMT CMT0263 UNDEFINED Down
Feb 24 2015 1:15AM Verigy ilv93k33 UNDEFINED Logged Out "


and every time that I want to refresh my pivot I need to delete the first 13 rows in order to run it.

there is an option to "guide" PowerPivot to null the first 13 rows automatically instead of manually edit that I do now?

after editing the file looks like this:

"
textbox69 textbox70 textbox71 textbox72 textbox73 textbox74 textbox76
Feb 24 2015 1:00AM CMT CMT0263 UNDEFINED Down
Feb 24 2015 1:00AM Verigy ilv93k33 UNDEFINED Logged Out
Feb 24 2015 1:00AM DBELKIN Verigy ilv93k34 UNDEFINED Active
Feb 24 2015 1:00AM GDLUSER CMT CMT0371 alpineridge Tester Maintenance Active
Feb 24 2015 1:15AM CMT CMT0263 UNDEFINED Down
Feb 24 2015 1:15AM Verigy ilv93k33 UNDEFINED Logged Out

"
THANKS a lot!!!

 

[ImkeF]

This is a job best be done in Power Query.
There's a dedicated menu item that let's you remove the first x lines from your Import table. You can then set this result to be transferred directly to your PP Data Model.
BR, Imke

 

[2avrham]

thanks I will try it..