Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to 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.
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.
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 ,
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.
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.