Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I'm uploading some data from an Excel file and it appears fine in the preview. However, when I hit load it only loads the column headers. I've copied and pasted only the value to get rid of any funky formulas (these have caused me a problem in the past). Any ideas?
Jossy
Solved! Go to Solution.
Hi,
It would appear some blank rows at the bottom of the Excel were causing the problem. Deleting them fixed it!
Jossy
Hi,
It would appear some blank rows at the bottom of the Excel were causing the problem. Deleting them fixed it!
Jossy
@Jossy, thank you for solving that.
To avoid "blank rows" you can convert the data-part of the excel sheet into a table, it should automatically get rid of the empty data.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.