Help with error in power query

[Anonymous]

Hello Power Query Power Users,

Can you help me get over this hump?

I get an error when I combine and transform from a folder.

Data Source: Excel file

The first rows are empty for Student Name and Student ID. It comes out empty from the database.

Student Name	Student ID	Wednesday	Thursday	Friday	Monday	Tuesday	Wednesday
		1/4//23	1/5/23	1/6/23	1/9/23	1/10/23	1/11/23
Arriaga	30311		P	A		A
Baeza	29152	A		P			P

Combine and Transform

Step 1: Get Data

Step 2: Folder

Step 3: Connect

Step 4: "insert file path"

Step 5: combine and transform data

Step 6: sample file>first file

The result is "Unexpected error occurred"

Attempted solution: Use the first rows as headers.

Result: "Unexpected Error occurred"

How do I fix the error? I believe the error is caused because of the empty first rows for Student Name and Student ID.

Any nudge is greatly appreciated.

[Anonymous · Accepted solution]

Figured it out. 

The data had to come in as a table.

Power Query could not find the table name because there was none in my original upload.

[Anonymous]

Here is a screen shot for more context.