In query, editor use this formula
let
Source = Excel.Workbook(File.Contents("D:\LTE_FBP.xlsm"), null, true),
cap_Sheet = Source{[Item="cap",Kind="Sheet"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(cap_Sheet,{{"Column1", type any}, {"Column2", type any}, {"Column3", type any}, …, {"Column941", type any}}),
#"Removed Top Rows" = Table.Skip(#"Changed Type",3),
#"Removed Bottom Rows" = Table.RemoveLastN(#"Removed Top Rows",22),
#"Removed Bottom Rows1" = Table.RemoveLastN(#"Removed Bottom Rows",1)
in
#"Removed Bottom Rows1"
remove row 2
let Source = Excel.Workbook(File.Contents("D:\_Ulm\# ECE Data Analyst\Power BI\LTE_eNB_Feature_Build_Plan 960051.xlsm"), null, true), cap_Sheet = Source{[Item="cap",Kind="Sheet"]}[Data], #"Changed Type" = Table.TransformColumnTypes(cap_Sheet,{{"Column1", type any}, {"Column2", type any}, {"Column3", type any}, …, {"Column941", type any}}), #"Removed Top Rows" = Table.Skip(#"Changed Type",3), #"Removed Bottom Rows" = Table.RemoveLastN(#"Removed Top Rows",22), #"Removed Bottom Rows1" = Table.RemoveLastN(#"Removed Bottom Rows",1), #"Remove Row 2 only" = Table.RemoveRows(#"Removed Bottom Rows1",1,1) in #"Remove Row 2 only"
remove 2 and 3
let
Source = Excel.Workbook( File.Contents("D:\_Ulm\# ECE Data Analyst\Power BI\LTE_eNB_Feature_Build_Plan 960051.xlsm"), null, true),
cap_Sheet = Source{[Item="cap", Kind="Sheet"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(cap_Sheet,{{"Column1", type any}, {"Column2", type any}, {"Column3", type any}, …, {"Column941", type any}}),
#"Removed Top Rows" = Table.Skip(#"Changed Type",3),
#"Removed Bottom Rows" = Table.RemoveLastN(#"Removed Top Rows",22),
#"Removed Bottom Rows1" = Table.RemoveLastN(#"Removed Bottom Rows",1),
#"Remove Row 2 only" = Table.RemoveRows(#"Removed Bottom Rows1",1,1),
#"Remove Row 3and4" = Table.RemoveRows(#"Remove Row 2 only",1,2)
in
#"Remove Row 3and4"
For more information on Power Bi, check the following Power Bi Training