Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using the built in Combine Files (via the GUI) (function in Power Query) to append multiple xlsx. files into 1 single fine, It works and does the job. However, with this method I get duplicate headers in my visual, shown in the snip
Then I used the Table.RemoveMatchingRows (Table Function) to get rid off the duplicated headers, it do not throw any error in Applied step as well as I checked the Advanced Editor and the query compiles successfully, I refreshed the model applied the changes, but still it shows the duplicated header.
How do I get rid off the duplicated headers
RD = Table.RemoveMatchingRows(#"Expanded Table Column1",{[Column1= "Column1",Column2= "Column2",Column3= "Column3",Column4 = "Column4",Column5= "Column5",Column6= "Column6",Column7= "Column7",Column8= "Column8",Column9= "Column9",Column10= "Column10",Column11= "Column11",Column12= "Column12",Column13= "Column13",Column14= "Column14",Column15= "Column15",Column16= "Column16",Column17= "Column17",
Column18= "Column18",Column19= "Column19",Column20= "Column20",
Column21= "Column21",Column22= "Column22"]}),
You could Promote Headers before combining, or just right click on any of the header values in your table and choose "Does not equal". Problem solved!
--Nate
Hi @smjzahid
From your M code, I can see the header with all "Column" were removed - "Column1", "Column2"...so you want to combine the tables from different files, do they have the exactly same headers? If yes, try to add a custom column, promote the header then combine. And you need to keep the data source, you can add a custom column in each table before combine them.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.