Cannot find file format binary

[OlaN]

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?

[v-kongfanf-msft · Accepted solution]

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.

[spencer_sa · Accepted solution]

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.

[v-kongfanf-msft · Accepted solution]

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.

[Expiscornovus]

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.