Forum Discussion
Error de filas de datos
Elimine el último paso "Changed Type" .
Esto debería eliminar el error.
También tendrá que averiguar la causa raíz del error (es decir, tal vez hay letras que son una columna que era mayormente números - y Power Query fue 'automáticamente' identificando esa columna como Números enteros).
Continued Contributor@bkan
Retroceda las transformaciones de consulta y asegúrese de que Power Query no asigna 'automáticamente' el tipo de datos a las columnas. Esto podría conducir a estos errores;
"Message = "The type of the value does not match the type of the column.", Detail = v], fieldTypes{i}})"
En su lugar: quite el paso "Tipo modificado" o llame explícitamente a los tipos de datos de columna usted mismo como parte de la consulta. Esto puede ser parte del problema.
Gracias Swise01
Así que en la consulta principal tengo , así que eliminar toda la parte de ("Changed type " hasta el final?
#"Promoted Headers" = Table.PromoteHeaders(#"Imported CSV", [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"OBJECTID", Int64.Type}, {"CASENUM", type text}, {"CASEREPORTNUMBER", type text}, {"SUPPLEMENT", Int64.Type}, {"MASTREL", type text}, {"CADAGENCY", type text}, {"CMINVESTUNIT", type text}, {"AGENCY", type text}, {"ORGAN", type text}, {"INCIDENTJURISDICTION", type text}, {"SUBMITTALORI", type text}, {"RAWLOCATION", type text}, {"GPSUSED", type text}, {"CSZ", type text}, {"GEOGRAPHICAREA", type text}, {"CADINCIDENTTYPE", type text}, {"NIBRSPRIMSUBCAT", type text}, {"CRCODE", type text}, {"CRDESCRIPTION", type text}, {"NIBRSCLASSHIERARCHY", type text}, {"WEAPONIBRCODE", Int64.Type}, {"PSCIPSUSPECTEDHATECRIME", type text}, {"PSCIPINTERPRETERRESOURCEUSED", type text}, {"PSCIPLANGUAGEUSED", type text}, {"REPORTEDBY", type text}, {"ASSISTEDBY", type text}, {"MEDIATEXT", type text}, {"DISPOSITION", type text}, {"PSCUNFOUNDEDREASON", type text}, {"DUPLICATEOFCASENUM", type text}, {"CLEARANCEBASIS", type text}, {"CLEAREDEXCEPTIONALLYON", type datetime}, {"ENTEREDBY", type text}, {"STLNRECFIREARM", type text}, {"QCLEOKA", type text}, {"UNFINCOTHERJURISDICTION", type text}, {"UNFINCOJORI", type text}, {"UNFINCOJCADAGENCY", type text}, {"UNFINCOJOTHRDEPT", type text}, {"PREMISETYPE", type text}, {"FORCEUSED", type text}, {"DOMESTICVIOLENCE", type text}, {"FIREARMINVL", type text}, {"HATECRIME", type text}, {"GANG", type text}, {"DRUGPARAINVL", type text}, {"SEXCRIME", type text}, {"IMMDETMENWRT", Int64.Type}, {"NFGW", type text}, {"WARRANTCOUNT", Int64.Type}, {"FELCHARGECOUNT", Int64.Type}, {"MISDCHARGECOUNT", Int64.Type}, {"CITINFCHARGECOUNT", Int64.Type}, {"OUTRIGHTARRESTCOUNT", Int64.Type}, {"SUMMONSARRESTCOUNT", Int64.Type}, {"WARRANTARRESTCOUNT", Int64.Type}, {"NARCANCOUNT", type text}, {"NSTOLENPROPTOTAL", Int64.Type}, {"NRECPROPTOTAL", Int64.Type}, {"PUBLICFLAG", type text}, {"MOTOCRINSERTEDDATE", type datetime}, {"P1RMSUPDATEDDATE", type datetime}}) in #"Changed Type"