Forum Discussion

aury_lola's avatar
aury_lola
Frequent Visitor
2 months ago

Gen 2 dataflow fails validation with "Pivot column" query

Hi all,   Has anyone else encountered this? I am at a complete loss...   I have had a Gen 1 dataflow running for over a year without any problem, but from the first moment I saved it as Gen 2, it...
dataflow
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
2 months ago

Hi aury_lola 

 

What I would recommend doing is taking your error that you have as well as your Power Query code and putting it into your favorite LLM and asking them to refactor this to see if that will resolve your issue. It might save you a lot of time and effort and then you can review the code to see what has changed to make it work successfully. Also could you make sure if you try a Data Flow Gen 2 with CICD as this is the latest version.

aury_lola's avatar
aury_lola
Frequent Visitor
2 months ago

Hi GilbertQ,

I'm not sure I understand what you mean by refactoring my query through LLM...

Anyway, yes it is a Gen2 CI/CD dataflow.

I don't know if you have read my reply to ibarrau below, but I tried multiple things for the past 3 weeks. And even if the "Pivot column" is literally the first step in my query, it fails the validation always with the same error message.