Pipeline Copy Data from Excel file in a Lakehouse is failing

Anonymous — Wed, 23 Aug 2023 14:04:45 GMT

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!

Re: Pipeline Copy Data from Excel file in a Lakehouse is failing

ajarora — Fri, 25 Aug 2023 18:30:12 GMT

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

topic Re: Pipeline Copy Data from Excel file in a Lakehouse is failing in Pipelines

Pipeline Copy Data from Excel file in a Lakehouse is failing

Re: Pipeline Copy Data from Excel file in a Lakehouse is failing