Loading Excel or CSV into Dataverse

[Manfredg]

Hello,

I try to load an excel with about 1 mio lines into dataverse - the setting is in Dataverse to german number formats. The excel is set to german formats too. when i load the excel into dataverse it shows me the right format on the sreen e.g. 14,17 in words 14 euro and 17 cent. when the excel is loaded it allways crashes in the fields with decimal values (value outside the range). the loaded records show then the value of the field 1 417,00 - when i do this with 10 testrecords it loads 8 out of 10 - but there is no difference in this 2 records. 

here is the error message 

a/v9.1/crd44_aartikeltests{ "crd44_anlage": "2009-12-09T00:00:00+00:00", "crd44_artikel": "1000", "crd44_bestand": 0, "crd44_bestsperre": false, "crd44_bezeich": "SCREW MACH PAN", "crd44_einheit": 1, "crd44_ekp": "1,1499999999999999", "crd44_ersatz": "VINTAGEPARTS", "crd44_liefer1": "HD", "crd44_mwst": 0, "crd44_nummer": 6, "crd44_reser": 0, "crd44_update": "2025-02-05T00:00:00+00:00", "crd44_vkp": "3,33", "crd44_wgr": "HDHDP" }

{"message":"A validation error occurred for crd44_aartikeltest.crd44_ekp. The value 1.15E+16 of type System.Double is outside the valid range(0 to 1000000000).","cdsErrorCode":"0x80044330","HelpLink":"http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException%3a80044330&client=pla...","InnerErrorMessage":"A validation error occurred for crd44_aartikeltest.crd44_ekp. The value 1.15E+16 of type System.Double is outside the valid range(0 to 1000000000).","cdsRequestId":"aff689d3-c7f2-4124-9eda-dd8a43965784","cdsRequestUtcTime":"3/29/2025 11:06:03 AM"}

your kind help would be very nide 

regds, Manfred

[v-veshwara-msft · Accepted solution]

Hi @Manfredg ,

Thank you for reaching out to the Fabric Community.

Based on your description, the issue appears to be related to Microsoft Dataverse and how it handles number formats during data import. Since Dataverse is part of the Power Platform, the best place to get specialized support would be the Power Apps Community – Dataverse Forum:

Microsoft Power Platform Community Forum Thread

Hope this helps. Pleas reach out for further assistance.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Thank you.

[Manfredg]

here the protokoll of the 2 lines out of 10y  - there are numbers i cannot see in excel or power query - no idea from where the come 

Name des Dataflows,Entitätsname,Startzeit,Endzeit,Status,Anzahl von upsert-Vorgängen,Anzahl einfügen,Fehleranzahl,Statusdetails

Neuer Dataflow 29.3.2025, 14:59:02,,29.3.2025 3:01:53 PM,29.3.2025 3:04:11 PM,Failed,,,,"Die Aktualisierung des Dataflows wurde abgeschlossen, aber für einige Zeilen konnte kein Upsert durchgeführt werden. Bitte überprüfen Sie die Fehler, bearbeiten Sie den Dataflow, um das Problem zu beheben, und versuchen Sie es noch mal. (Anforderungs-ID: 4cc2558d-007e-4884-bbea-adfd6cf45eec)"

Neuer Dataflow 29.3.2025, 14:59:02,Tabelle1,29.3.2025 3:02:43 PM,29.3.2025 3:04:05 PM,Fehler,0,8,2,

Tabellenname,Zeilen-ID,Anforderungs-URL,Fehlerdetails

Tabelle1,0c8c22de-ee1b-44e2-a9d1-3c051458c6e0,"https://orgeecf34b4.crm4.dynamics.com/api/data/v9.1/crd44_aatests{

""crd44_anlage"": ""2009-12-09T00:00:00+00:00"",

""crd44_artikel"": ""10001"",

""crd44_bestand"": 0,

""crd44_bestsperre"": true,

""crd44_bezeich"": ""CLAMP"",

""crd44_einheit"": 1,

""crd44_ekp"": ""0,56999999999999995"",

""crd44_ersatz"": null,

""crd44_liefer1"": ""HD"",

""crd44_mwst"": 0,

""crd44_nummer"": 7,

""crd44_reser"": 0,

""crd44_update"": ""2025-02-05T00:00:00+00:00"",

""crd44_vkp"": ""1,67"",

""crd44_wgr"": ""HDHDP""

}","{""message"":""A validation error occurred for crd44_aatest.crd44_ekp. The value 5.7E+16 of type System.Double is outside the valid range(0 to 1000000000)."",""cdsErrorCode"":""0x80044330"",""HelpLink"":""http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException%3a80044330&client=pla..."",""InnerErrorMessage"":""A validation error occurred for crd44_aatest.crd44_ekp. The value 5.7E+16 of type System.Double is outside the valid range(0 to 1000000000)."",""cdsRequestId"":""1ff6c1df-c8eb-453c-baaa-fbaeff48b553"",""cdsRequestUtcTime"":""3/29/2025 2:04:04 PM""}"

[Manfredg]

p.s. if i enter a value manually in a float field it accept 14,17 !!!

AND text is not i option i prefer because of the calculation afterwards in power apps - it's the a nightmare allways convert every field

[Manfredg]

the power query function within the dataload is set to german too - i just checked - but it still loads in dataverse us-english format