Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Fast Copy DataFlowGen2

Hi Team, Im trying to move files from azure data lake gen2 to lakehouse in ms fabric through dataflowgen2 using fast copy.But every time i do it im getting following error.       is this...
Dataflow
Need Help
srinidhiprabhu's avatar
srinidhiprabhu
Microsoft Employee
9 months ago

The CreateNavigationProperties option is why you would be failing to use Fast copy previously. Have you tried saving your dataflow after removing the option to check if you still hit the same "Fast Copy is not supported with the current set of transformations on the query" error? While the error in the indicator does suggest that Fast copy may not end up being used, it is a check at design-time, and runtime behavior can be different

SofBL's avatar
SofBL
Advocate II
9 months ago

Although I tested this on the 31th of october. I decided to give it a new try with a brandnew dataflow gen2. Doing exactly the same steps as prior it now does state that fast copy will be used. 
To explain it in more detail, I create the connection to the database and then edit the M query manual to remove the section stating 

, CreateNavigationProperties = false

after doing that it worked.  I am happy. 

 

  • srinidhiprabhu's avatar
    srinidhiprabhu
    Microsoft Employee
    9 months ago

    SofBL Glad to see it working for you.