Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data Flow errors NVARCHAR(16) EXEC (@altersc

HI Team,   My dataflow used to run without any error but since last week I am getting below error and unable to figure out why I am getting this error and how to fix it. All the data are from excel...
Need Help
GregoryDF's avatar
GregoryDF
Frequent Visitor
5 years ago

Hi. I've got the same issue on some of my dataflows since the june update. On my side, the error was

"PipelineException: Incorrect syntax near 'article'. Unclosed quotation mark after the character string ' NVARCHAR(2);'; EXEC (@alterscript);'".

 

I spent quite some time checking for everything and like you there were no issue, everything was working fine, but still I was not able to refresh. The solution was to remove the character ' from columns names. On the case for which I gave the example above, I have one column named "Groupe d'article", and even though it was working fine until now, and it still is for dataflows not combining sources, it looks like since the last update it's not working anymore and I need to remove this character from the names. And then it works again...

 

So check for a special character or look for column names with the error hint. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI GregoryDF 

     

    Oh, seems I need to rebuilt all my flows I have 15 flows and as of now 3 are having this error. I will check the raw file too if can do a workaround else no other choice. The problem with dataflow is it works but all off sudden it will fail specially when there is update in PBI Service and we don't get clue where the actual issue is.

     

    But the same is working when I replicated the dataflow even with incremental refresh. 

    Anyway will give it a try.

     

    Thanks

    Mukesh

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      5 years ago

      Hi Anonymous ,

       

      Is your issue solved now?

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!