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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors