Forum Discussion
Data rows error
Anonymous
Delete the last step "Changed Type" .
This should remove the error.
You will also need to figure out the root cause of the error (i.e perhaps there are letters is a column that was mostly numbers - and Power Query was 'automatically' identifying that column as Whole Numbers).
Thanks Swise01
So in the main query i have , so delete the entire part from (#"Changed type " till the end?
#"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"
Anonymous
It's probably easier to delete the step from the Power Query UI:
Otherwise you'll be chasing down comma issues.
Do not see that step in my main query
Anonymous
Delete the last step "Changed Type" .
This should remove the error.
You will also need to figure out the root cause of the error (i.e perhaps there are letters is a column that was mostly numbers - and Power Query was 'automatically' identifying that column as Whole Numbers).