How to import a new scheme from an excel source to data factory?

Question

Greetings community, I am trying to update my schema in one of my datasets, but it throws this error message:

Failed to load:

Invalid excel header with empty value, filename is '', sheetname is 'Mayo', the row number is '', the column number is ''. Activity ID: fa2a2b8a-fb42-49bc-875f-9927e25dd2fe

Answer 1

It is either you add a transformation to allow NULL values in column headers :

ifNull({ColumnName}, 'Unknown')  

Or click on schema and regenerate

1. open the source file and navigate to the specific sheet.
2. in header row - go to the column AFTER the last column.
3. Select ALL (CTRL + SHIFT + RIGHT)
4. Delete (CTRL + -)
5. Save
6. Turn 'Use first row as headers' back on
7. Preview data

https://learn.microsoft.com/en-us/answers/questions/761277/invalid-excel-header-with-empty-value-when-last-ce

Answer 2

Genesis Pena J ,

Kindly delete the empty columns. It seems the empty columns were used but then the values & column names were deleted, but because the columns were formatted it seems to have caused this issue. If this doesn't work for you, I would say copy all the data, just the columns with values, and then paste to a new excel file.