cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
papolley
Microsoft
Microsoft

Dataflow refresh errors with <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">

Hello!

 

I am trying to load in data via kusto to my dataverse environment through dataflows. Most of the data loads in just fine, but, lately, I have two rows that error when the refresh happens. The error logs look like this:

 

Table name  Row idRequest urlError details
Query[someid]https://[id].crm.dynamics.com/api/data/v9.1/[cr480_object_name](cr480_primary_link_guid=[someguid])?$select=modifiedon,createdon{
"cr480_name_friendly": "厚生労働省",
"cr480_country": "Japan",
"cr480_name": "厚生労働省保険局保険者向け中間サーバ更改",
"cr480_inclusioncriteria": "NO_FILTER",
"cr480_totalrevenue": 0.0,
"new_description": null,
"cr480_primary_link_guid": [GUID]
}
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">
Query[some-other-id]https://[id].crm.dynamics.com/api/data/v9.1/[cr480_object_name](cr480_primary_link_guid=[someguid])?$select=modifiedon,createdon{
"cr480_name_friendly": "Technologies",
"cr480_country": "India",
"cr480_name": "​FY22_SMB_India",
"cr480_inclusioncriteria": "NO_FILTER",
"cr480_totalrevenue": [somenum],
"new_description": null,
"cr480_primary_link_guid": "[GUID]"
}
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">

 

 

I suspect this may have something to do with invalid characters, but I am uncertain which characters are invalid and if that is even the issue. Has anyone here run in to anything like this in the past? Maybe it's something to do with  "厚生労働省保険局保険者向け中間サーバ更改" ?

 

Any and all help would be greatly appreciated!

 

Thank you!

4 REPLIES 4
rampprakash
Super User
Super User

Hi @papolley 

 

Can you please try passing the value as English and test again to confirm weather the issue is from language or not.

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

Hi! Thank you for responding!

 

I can certainly try! How would you suggest doing so? Is there a dataflows functionality that I could use to do a translation in place? Could I maybe parse away invalid characters?

 

Thank you!

Eric503
Frequent Visitor

Any update on this? I have the same issue.  Trying to import 77 rows with 8 Columns of data, get this error on 2 rows. 

 

papolley
Microsoft
Microsoft

@Eric503 unfortunately I had to modify the data from the process that loaded the data into our external source.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (1,831)