Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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.
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.
Here is a screen shot for more context.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
42 | |
35 | |
27 | |
18 | |
17 |