Forum Discussion
Solved
dataflow - if there is a row present
hello, in the dataflow gen2, there are several steps from navigation of the source all the way to pivot column. After the pivot, the step is to rename column. But the flow fails on this rename step...
I would add a dummy row with the necessary columns before that step, so that the step doesn't fail, and then I would filter away the dummy row afterwards.
I created a HelperRow which only has columns and no rows.
Then after the pivot step, I appended this helper row.
It seems fine now
thank you
Hi arkiboys2
If you use Table.RenameColumns to rename columns, a simple solution is to add MissingField.Ignore at the end. MissingField.Type - PowerQuery M | Microsoft Learn
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!