Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
CostaBella
Frequent Visitor

Remove 2nd Header In Power Query Editor

I have a yearly report that I am working on. It pulls a list of any construction projects that are located on a hurricane evacuation route. The problem is that the data I am connecting to is somehow adding an extra header row halfway through the data. Is there a simple way to remove this? I initally just removed that specific row, but there is no guarantee that the 2nd header will be in the same row next year when I run the report and I don't want it to delete information that is needed. The first picture below is the header at the top of the data that I want to keep; 2nd picture is row 22 and is a duplicate header.

CostaBella_0-1686065207817.png

 

 

CostaBella_1-1686065232433.png

 

Any advice will be greatly appreciated!

1 ACCEPTED SOLUTION
JamesRobson
Resolver II
Resolver II

Potential simple fix would be to filter Contract ID to exclude "Contract ID" as I doubt you'll have an ID of that and if it starts to appear multiple times (guessing your source data has it across multiple pages or something) as you data grows it will remove every occurance of "Contract ID".

 

= Table.SelectRows(#"Changed Type", each ([Contract ID] <> " Contract ID"))

 

Thanks,

View solution in original post

2 REPLIES 2
JamesRobson
Resolver II
Resolver II

Potential simple fix would be to filter Contract ID to exclude "Contract ID" as I doubt you'll have an ID of that and if it starts to appear multiple times (guessing your source data has it across multiple pages or something) as you data grows it will remove every occurance of "Contract ID".

 

= Table.SelectRows(#"Changed Type", each ([Contract ID] <> " Contract ID"))

 

Thanks,

I have been working in Power Query Editor for a little over a year now (by no means an expert) and I am upset that I did not think of this. Thank you for simplifying it for me! I guess I was just overthinking it.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors