Forum Discussion
Cannot find file format binary
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?
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
3 Replies
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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.
