Pipeline Copy Data from Excel file in a Lakehouse is failing

[bryanshaw46]

I am using OneLake explorer to move an excel file from my laptop to the Lakehouse Files.

I then create a Pipeline, Copy Data and I can preview the source.  Everything looks great.

For the destination, I just want to get the data from Excel into SQL so I can use it in a Power BI report.  I have tried to copy the data into a table in the same lakehouse and I have tried a Data Warehouse.

I see the message that it fails on Validation, but there are no subsequent details on the Monitoring Hub.  I only see the first run history and no others, dispite having ran it several times.

Thanks for the help!

[ajarora]

Hello, can you please expand what you mean by a message that fails on Validation. Please add screenshots.