Forum Discussion
Solved
Loading Excel or CSV into Dataverse
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 dataver...
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.
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=platform"",""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""}" |