PQ - from excel workbook with/without promote headers

with Table.PromoteHeaders

Code:

---

let
    Source = Excel.Workbook(File.Contents("(path_to_the_file)\fakedata-0p7sxQX3Zv8cX2nyJaCYn.xlsx"), null, true),
    #"fakedata-0p7sxQX3Zv8cX2nyJaCYn_Sheet" = Source{[Item="fakedata-0p7sxQX3Zv8cX2nyJaCYn",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(#"fakedata-0p7sxQX3Zv8cX2nyJaCYn_Sheet", [PromoteAllScalars=true])
in
    #"Promoted Headers"

---

without Table.PromoteHeaders

Code:

---

let
    Source = Excel.Workbook(File.Contents(("(path_to_the_file)\fakedata-0p7sxQX3Zv8cX2nyJaCYn.xlsx"), true, true),
    #"fakedata-0p7sxQX3Zv8cX2nyJaCYn_Sheet" = Source{[Item="fakedata-0p7sxQX3Zv8cX2nyJaCYn",Kind="Sheet"]}[Data]
in
    #"fakedata-0p7sxQX3Zv8cX2nyJaCYn_Sheet"

---

one line less and the effect is the same :)

name	phone	email	address	postalZip	region	country	list
Porter Franklin	(625) 763-3454	urna.nec@protonmail.net	949-736 Vitae St.	16112	Lipetsk Oblast	Nigeria	11
Kasimir Ramirez	(394) 402-7467	ante.lectus@outlook.couk	Ap #611-325 Lectus Ave	60746	Zuid Holland	Austria	7
Darius Stone	1-184-757-7028	ipsum.dolor@protonmail.net	P.O. Box 830, 967 Orci Rd.	30546	Madhya Pradesh	China	3
Linus Jarvis	1-839-469-3822	feugiat.metus@outlook.edu	Ap #965-6264 Suspendisse Road	05-958	South Island	Chile	1