topic Re: Publishing error: unknown error for a pipeline in Pipelines

Publishing error: unknown error for a pipeline

MichBDO — Fri, 16 Jun 2023 06:52:15 GMT

I created a pipeline which includes a single copy data activity.

The source in the copy activity points to a XLSX file in a lakehouse file folder. The destination points to a new table in the lakehouse named 'SourceCSV' (yet to be created through this copy activity).

When trying to save I got the error:

Publishing error: {"code":UnknownError","pbi.error":{"code":{UnknownError"}}

I cannot find the exact cause of this error.

Re: Publishing error: unknown error for a pipeline

sudhav — Mon, 19 Jun 2023 16:59:27 GMT

Hi, in pipeline case, you have to take care of import scheme option, there you need to map the column names and data types, then you will get succeeded output.

If I answer your question, please mark it as solution.

Re: Publishing error: unknown error for a pipeline

ajarora — Mon, 19 Jun 2023 22:21:37 GMT

Looks same as this post:

https://community.fabric.microsoft.com/t5/Pipelines/Unable-to-Publish-Pipeline-quot-code-quot-UnknownError-quot-quot/m-p/3274331#M188

Please confirm if not.

Re: Publishing error: unknown error for a pipeline

MichBDO — Thu, 22 Jun 2023 12:49:33 GMT

Hi Sudhav, thank you for responding.

The file was too big to import a schema so I first imported the file with just the headers and then changed the source back to my large excel file.

I still get the same error as I did the before.

Re: Publishing error: unknown error for a pipeline

MichBDO — Thu, 22 Jun 2023 12:53:00 GMT

The error in that post is the same but the solution is not applicable to my case. I'm not using parameterization in my table name. And I have also tried changing the destination from table to file which still gives the same error so it is not the same problem.

Re: Publishing error: unknown error for a pipeline

ajarora — Thu, 22 Jun 2023 19:19:24 GMT

Thanks for confirming. Can you log a support ticket with enough details ? If not, can you share your workspace id and a rough timestamp when this happened ?

Re: Publishing error: unknown error for a pipeline

MichBDO — Fri, 23 Jun 2023 08:58:38 GMT

Thank you for your quick answer. I have submitted a ticket and tried to be as detailed as possible.

Re: Publishing error: unknown error for a pipeline

MichBDO — Thu, 29 Jun 2023 08:21:26 GMT

The 'Unkown error' is now replaced by a 'RequestValidationFailed' error.
I have tried replacing the xlsx file with a csv file with the same data. Here it does work. Therefore I'm a bit confused as to why this error only shows for an xlsx file. Maybe due to an encryption on the excel file? Although I didn't encrypt it and it also doesn't show any encryption.