cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors