table data for power query in the first column and row is ignored?

[maeztr]

is it true?. if table data for power query in the first column and row is ignored? (in column A and row 1)

[MarvinP]

Hy maeztr,

No! I don't think if you pull in a Table of data into Power Query, it will ignore anything. If you have a blank row 1 and a blank column A and your table starts in B2 and you pull that table into PQ then the first row and column in your sheet won't be pulled in because they aren't part of the TABLE....

[maeztr]

Hy maeztr,

No! I don't think if you pull in a Table of data into Power Query, it will ignore anything. If you have a blank row 1 and a blank column A and your table starts in B2 and you pull that table into PQ then the first row and column in your sheet won't be pulled in because they aren't part of the TABLE....

Hy MarvinP,
i took table from workbook not from recent sources. so no drag process to select table. and in my power query column A and Row 1 don't exist

[sandy666]

A1 becomes the header line and the first column in PQ
but rather don't use worksheet nomenclature but rather Power Query

btw. DON'T QUOTE WHOLE POST please