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 file. Below are things I tried

 

1. Replicated the dataflow and found no problem, ran successfully

2. Tried with Power BI Desktop and found no issue, all data load was successful.

3. All other dataflow running fine except 3 with the below error input from same file but different sheet.

 

Based on above I can't find any issue with my raw file.

Can't rerun the entire dataflow as it has incremental refresh with last year data.

 

 

Thanks

Mukesh

Need Help

5 Replies

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

    Hi  Anonymous ,

     

    If you disable "incremental refresh",will the issue still exist?

     

    Best Regards,
    Kelly

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      HI v-kelly-msft 

       

      Yes I did and still it didn't work.

       

      Thanks

      Mukesh

  • 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!