0

I'm connected to a File System Linked Service where the .xlsb file is and I want to create a CSV file with that information.

This .xlsb file has several sheets and I only need one.

Is it possible to read .xlsb files and select the sheet that we want in Data Factory dataset and copy data activity?

Thanks

Dory
  • 19
  • 5

1 Answers1

1

It seems it is not possible to select .xlsb file as source in Azure Data Factory.

Only the following document types are allowed.

enter image description here

Workaround:-

You can convert .xlsb file to excel file, there are lot of tools available on the Internet.

Then you can Select Name or Index in Worksheet mode as shown in below image.

enter image description here

For reference - https://learn.microsoft.com/en-us/azure/data-factory/format-excel

Abhishek K
  • 3,047
  • 1
  • 6
  • 19