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 id | Request url | Error 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!
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!
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.
@Eric503 unfortunately I had to modify the data from the process that loaded the data into our external source.
User | Count |
---|---|
20 | |
11 | |
9 | |
5 | |
5 |
User | Count |
---|---|
32 | |
32 | |
18 | |
18 | |
7 |