Forum Discussion

mike9999's avatar
mike9999
Advocate I
1 year ago
Solved

Dataflow gen2 binding to default data destination

Hey- Whenever I configure the "Bind to default data destination" for the output of a dataflow gen2 to the Lakehouse - it attempts to bind internal dataflow functions like "Transform Sample file", "T...
Need Help
  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    1 year ago

    Hi mike9999 

    • Currently there are no settings in place to disable Functions or Sample files getting written to the lakehouse / warehouse.
    • But it is not necessary to have a Transform file / funtions in the Power Query layer. If you see the Transform file funtions those are all created by Power Query automatically. You can copy the logic of the Transform File function and past it inside your main query logic.
    • Once you have copied the logic and fixed your M code. You can delete the transformation functions and sample file associated with it.

    Thanks,

    Jai Rathinavel

Jai-Rathinavel's avatar
Jai-Rathinavel
Super User
1 year ago

Hi mike9999 

  • Currently there are no settings in place to disable Functions or Sample files getting written to the lakehouse / warehouse.
  • But it is not necessary to have a Transform file / funtions in the Power Query layer. If you see the Transform file funtions those are all created by Power Query automatically. You can copy the logic of the Transform File function and past it inside your main query logic.
  • Once you have copied the logic and fixed your M code. You can delete the transformation functions and sample file associated with it.

Thanks,

Jai Rathinavel