Power Query Issue

[BrettOlbrys1]

Good morning. This has not happened to me before, so not sure why this occurred. I have an external data file, and I am using Power Query to get data "from web" to a designated sheet in a second file. The data being retrieved is not a formatted table, it is all of the data in a specific sheet. The data is setup properly with column headers in row 1 and all of the data resides below the headers.

When Power Query retrieves the data, it has ALWAYS retrieved it correctly, with all of the headers intact in row 1, and of course it creates a formatted table when it is imported. When I just tried to do this again, Power Query is importing the data but placing all of the headers in row 2, with blank headers in row 1. This of course messes up my file because all of my formulas are now pointing to incorrect cells.

When I import, telling it to start in A1, so why is it starting is A2?

Thanks

Brett

 

[Matt Allington]

If you import the sheet, you should not be specifying a starting cell, the sheet brings everything. If there is one column that always must contain data, you can put a filter on the column to “remove blanks“. You would need to do this first, immediately after the connect to sheet step. In future, if there is no first blank row, this step will be ignored. If it is there, it will be removed.
as to why? IDK. Maybe there is a hidden carriage return, or something.