Unknown error DataFlow Gen2 (CI/CE Preview)

[Theo_MS]

Hello,

with the Dataflow Gen2 (CI/CE Preview), two tables from the same dataLake are treated and only one is successful.
Both table have the same basic operation (delete columns and change column type) and then save in a second datalake.

The error rmessage isn't clear to identify the issue:

Also tried with and without "Enable Staging"

Any advice or help will be appreciate.

Regards

[Theo_MS]

Hi @Anonymous,

thanks for your reply. 

indeed one value is making this issue. (text in a integer format)

It could be more appreciable to have a more details of the error; like the column name.

Regards,

[Anonymous · Accepted solution]

Hi @Theo_MS ,

According to the information in the screenshot you provided, Error Code 104100: This is an error related to data evaluation or localization, which may be related to the inclusion of special characters in the data or a format incompatible with the current regional settings.
In addition there may be some differences in the data (e.g. column content, formatting or structure) of HRP1001 compared to the successfully processed table HRP1000.

This can be troubleshooted in the Power Query Editor by loading table HRP1001 separately.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.