Data Flow errors NVARCHAR(16) EXEC (@altersc

[Anonymous]

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

[GregoryDF]

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]

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]

Hi @Anonymous ,

Is your issue solved now?

Best Regards,
Kelly

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

[v-kelly-msft]

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]

HI @v-kelly-msft 

Yes I did and still it didn't work.

Thanks

Mukesh