Forum Discussion
Solved
ADF pivot vs fabric dataflow pivot
there is a powerful pivot activity in ADF dataflow. the pivot in fabric dataflow gen2 does not seem to have quite the same functionality as that in ADF. for example: in ADF dataflow pivot it has th...
I created the helper row by using Enter Data. Then I copied the generated M code into the main query manually.
But you can do it easier:
You can create it as a separate query by using Enter Data, and then appending that query to your main query by using the menu option for Append queries.
Inside the Dataflow Gen2, you can click Get Data -> Blank query, and then paste the code inside there, then click Next.
I am now implementing your suggestion on the whole actual data. but not sure why the remove duplicates only returns one row whereas it should return four rows similar to the example I sent you