azure-data-factory

How to change the File Extension with Azure Fabric Pipelines

I am working with Azure Fabric Data Pipelines. I would like to change the File Extension to .csv but it's greyed out and thus won't let me change the extension. Can someone let me know where to the change the File Extension please.

In Azure Data Factory it's not greyed out and thus it is easily changed to any extension you wish. Not sure why it's greyed out here

enter image description here

Solution

  • In Azure Data Factory it's not greyed out and thus it is easily changed to any extension you wish. Not sure why it's greyed out here

    It's same as Azure Data factory in fabric pipelines. The File extension option can only be edited if there is no file name given in the file path. You can see the same as below.

    enter image description here

    If there is no File name given, it will give the option to specify what type of file you need to generate. By default, it will show .txt.

    If you need to mention the file extension, you can remove the parameter or any expression first in the File name and give the desired file extension. After that, you can give your parameter expression.

    enter image description here

    But giving the file extension along with the file name in the expression is the better approach when you are generating any dynamic files.

    Give the file name like <filename>.csv in the parameter itself.