topic Cannot find file format binary in Pipelines

Cannot find file format binary

OlaN — Wed, 23 Oct 2024 08:46:05 GMT

Doing a tutorial for MS Fabric, trying to create a Data Pipeline to load data to a Lakehouse. In step "Connect to data destination" I should choose file format binary, but that option is not available. Have I done anything wrong?

Re: Cannot find file format binary

Expiscornovus — Wed, 23 Oct 2024 11:51:21 GMT

Hi OlaN,

Which tutorial are you following? This one from Microsoft?

https://microsoftlearning.github.io/mslearn-fabric/Instructions/Labs/04-ingest-pipeline.html

If not, can you share the link of the steps you are following? This would be helpful.

Re: Cannot find file format binary

Anonymous — Wed, 30 Oct 2024 06:55:15 GMT

Hi OlaN ,

You can adjust the data type of the columns in the table to binary in the mapping step, but the binary type is not supported for file format.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Cannot find file format binary

spencer_sa — Wed, 30 Oct 2024 12:33:43 GMT

Assuming you're using the Copy Data assistant to set the copy up, you'd need to select the source as a binary to be able to output the file as a binary. (Binary doesn't try to decode the data).

If you try to replicate just using a Copy data activity, you'll find a variant of this error saying that if the destination is binary, then the source must be binary.

In short; If you try to parse the file, you have to specific the output type - it can't be binary.