Forum Discussion
Help with error in power query
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.
- Anonymous3 years ago
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.
2 Replies
- AnonymousNot applicable
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.
- AnonymousNot applicable
Here is a screen shot for more context.