Forum Discussion
Create Dataflow Gen 2 without Data destination to test - unable to add Data destination later
When I create a Dataflow Gen 2 without Data destination just to test that the query is working properly in Dataflow Gen 2 as part of troubleshooting I do not see a way to add the Data destination later.
When I go back into Dataflow Gen 2 edit mode there doesn't appear to be any option that I can see that allows you to add the Data destination.
Am I missing something?
Or perhaps the only current option is to delete and recreate the add the Dataflow Gen 2 with a Data destination?
Hey!
The data destination logic is set up as an extra (last) step to a query of your choosing. Make sure that you select the query of your choice and then you should be able to see the "output destination" button in the ribbon, the diagram view or even in the applied steps section available to you.
If you are not able to see it, could you please share a screenshot of what you see? Just make sure that you select a query first.
11 Replies
Hey!
The data destination logic is set up as an extra (last) step to a query of your choosing. Make sure that you select the query of your choice and then you should be able to see the "output destination" button in the ribbon, the diagram view or even in the applied steps section available to you.
If you are not able to see it, could you please share a screenshot of what you see? Just make sure that you select a query first.
Hi,
where is the solution please ? I have always the same issue. When I prepare a dataflow gen2 (reading from sharepoint, load to lakehouse), everything looks great.... but then when I publish it Fabric generates a new tasks to Flow with a alert/bug.
If a delete these task. I can not to add destination (lakehouse) again anymore.task with alert:
let WriteToDatabaseTableFrom_TransformForOutputToDatabaseTableFrom_Query = Pipeline.ExecuteAction(ValueAction.WithTransaction([Target = #"DestinationForWriteToDatabaseTableFrom_Query (2)"], (txn) => {TableAction.DeleteRows(txn[Target]), TableAction.InsertRows(txn[Target], TransformForOutputToDatabaseTableFrom_Query), Action.DoNothing})) in WriteToDatabaseTableFrom_TransformForOutputToDatabaseTableFrom_Querywith error message:
Expression.Error: The import Pipeline.ExecuteAction matches no exports. Did you miss a module reference?I am not even google this function.
Hi,
Did you create this dataflow from a template that you had where the load destination was defined?
