Combing Multiple Files Headers HELP PLS

Aread62127

New Member
Joined
Jan 21, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hi All,

I have combined a folder with identical files (30+) with identical headers. When Power BI Combines them it doesnt recognise the headers and puts them as the first row instead. How do i stop this or promote the first line as a header but remove the headers from the data from all other files?? please help
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
did you try Get Data - File - Folder ?
if it doesn't work
- sort descending
- table.skip (number of rows with headers -1)
= promote
 

Aread62127

New Member
Joined
Jan 21, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
What I'm doing is

Get data
File
Folder
Select folder
Combine and transform data
Then right click on parameter and press transform

When it loads the data is shows each file, but when I press the 2 arrows under data it doesn't recognise the column headers and just says column 1 column 2 etc. The columns are shown as the first line of data instead
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
there should be two columns (they have names?) with double arrows, could you be not so enigmatic? ;)
 
Last edited:

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
there should be two columns (they have names?) with double arrows
Could you do the same with Excel not PBI?

binary.png
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,126,928
Messages
5,621,642
Members
415,849
Latest member
PhoenixRising2015

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top