Power Query Issues

[thewiseguy]

I'm new to PQ so please bear with me. I made changes in the table headers in the source data and now my data has shifted down as seen below. Row C was my original header. What is going on and how do i correct this? This is not the first time this has happened and I am not understanding what is going on. Any help is greatly appreciated.

v2023.10.xlsm
	A	B	C	D	E	F	G
1	Column1	Column2	Column3	Column4	Column5	Column6	Column7
2
3	MaskedPartNumber	PartNumber	Indoor_Outdoor	Product_Type	Product_Subgroup	Application_Subgroup	Size
4	TBD 1/2-EMT Conduit 1/2-Inch x 10'	1/2-EMT	Indoor	Materials	Conduit and Fitttings
5	TBD 2-Screw EMT Set Screw Coupling 3/4-Inch	249032	Indoor	Materials	Conduit and Fitttings
6	TBD Duplex AC/Flex Connector for MC, 3/8"	EGS DC-5500	Indoor	Materials	Conduit and Fitttings
7	TBD Insulated Throat Straight Duplex Connector 3/8-Inch Snap2IT	3838AST	Indoor	Materials	Conduit and Fitttings
Materials

 

[alansidman]

When you loaded your source data, you may not have checked the box that indicated that the first row of the range/table were headers. If this has happened then highlight the first row and delete it. Then promote the new first row which contains your headers to header. Using your sample

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Removed Top Rows" = Table.Skip(Source,1),
    #"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true])
in
    #"Promoted Headers"

 

[thewiseguy]

Alan - thank you. I did not check that box off, so to avoid any issues going forward, if i wanted to make those changes now, on a number of source data sheets without having my data move, how would i make the first row into a header?

please see the attached image. this is what my sheets look like.

 

[alansidman]

On Transform Tab, select Use First Row as Headers. However, in your image, it appears you already have headers in place.

 

[thewiseguy]

is it possible that whathappened in my first image occured even when headers were in place? I'm fairly confident I connected all of the data the same.

 

[alansidman]

If you don't click on the checkbox, then the image in your first post is the result.