Dataflow Text Column Invalid Character

(0) Share

Report

Posted on by KSven

182

Hi lovely Community,

I've created a Dataflow with Power Query to integrate some Records into my tables.

There's a classic Text Column "Comment".

I got the following Error Message:

It seems to be a normal Euro character "€"

Does it means I have to replace such characters for the Integration? Or is it a Encoding topic?

BR,

Sven

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-jefferni on at

Like (1)

Report

Hi @KSven ,

Could you please share the details about the original table? Which kind of the data source is the table?

As per you mentioned, could you please try to add double quotes to quote the whole comments and force them to be text type. Or you could remove that "€" in the table and edit the column in Power Apps.

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
KSven 182 on at

Like (0)

Report

Hi @v-jefferni ,

sorry for my late reply and thank you very much for your help!

Just wanna explain may full problem:

1. My datasource is a CSV file with ANSI encoding. Here I have some Records like this:
So there are some Special characters from SAP datasource, original Record should be: "########Spedition Mickeleit Gm45329"

2. Reading with Power Query looks like this:
There are now special characters inside...

3. Now I'm trying to integrate my Records to Datavers via Dataflow, but get the following error message:
Reason: Bad Request, Header x-ms-client-request-id 2f2bec2d-955b-42c6-869c-e6da423d4b0b, Error code: 0x80040278, Message: Invalid character in field 'crefb_customer': '', hexadecimal value 0x01, is an invalid character."

So how to replace this record when I can't see the characters in Power Query?

BR,
Sven

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @KSven ,

As per your description, you would be better export data from SAP encoding to utf-8. If you would like to convert the CSV file encoding with utf-8, please try open it in Notepad then save as utf-8 encoding.

Non-English characters, not only "€", are not supported in ANSI so it would display incorrectly, and this also caused the issue when you are working with Power Query in PowerApps.

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
KSven 182 on at

Like (0)

Report

Hi @v-jefferni ,

yes I guess there's no other way to push the SAP colleagues to export data correctly...

Thank you very much!

BR,
Sven

Was this reply helpful? Yes No