Azure Data Factory - Dataflow: Connection to the dataset fails

Kuersat1 25 Reputation points
2023-07-24T11:59:04.4533333+00:00

I have created a data flow and tried to test the connection to the dataset. However, the connection fails and returns the following error message:

"Request headers must contain only ASCII characters. - RunId: da89b4eb-b560-4e54-8ae2-a1598f71bcf3"

If I test the connection in the dataset, it works. I can also preview the dataset successfully.

Additionally, I have ensured that the headers in the dataset consist only of ASCII characters.

Are there any other potential sources of errors that I should consider?Screenshot 2023-07-24 135538_defaced

Screenshot 2023-07-24 134439_defaced

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,205 questions
{count} votes

Accepted answer
  1. Konstantinos Passadis 19,376 Reputation points MVP
    2023-07-24T14:28:15.64+00:00

    Hello @Ace-7747 !

    Welcome to Microsoft QnA!

    The error message "Request headers must contain only ASCII characters" indicates that the request headers in your JSON file contain non-ASCII characters. To resolve this issue, you can try encoding your JSON file in ASCII format. In the Notepad++, try to convert the encoding of your file to ASCII. To do this, open your JSON file in Notepad++, click on the encoding and select "Convert to UTF-8" and see if it helps

    Also try to import the schema on the source setting if applicable

    I hope this helps!

    Kindly mark the answer as Accepted and Upvote in case it helped!

    Regards

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.