#"Kept Errors"

[sudanaditya]

Hello All - The data reresh stops after throwing this error. I am not able to see the error in the table .In the advance editior below is the error . Need help and guidance. In the community I found that need to change the data structure from text to number or vice versa but not sure on which column since I am not able to localize the error .

Thanks in advance

Regards

Sudan

let
Source = BPHRequirementsTracker,
#"Added Index" = Table.AddIndexColumn(Source, "Row Number" ,1),
  #"Kept Errors" = Table.SelectRowsWithErrors(#"Added Index", {"ContentTypeID", "BPHRequirementID", "RequirementName", "RequirementStatusOLDValue", "BIReportNumber", "Comments", "FitAnalysisValue", "APQC", "ProjectIDValue", "Modified", "Capability", "CreatedById", "TrainingDocLink", "TestScriptLink", "TestDesignPriorityValue", "WorkInstruction", "TestScriptValidationDate", "ProcessFlow", "TrainingDoc", "BPHTrackValue", "RequirementDescription", "PCFID", "WaveIVProjectReviewed", "RFC", "AutoSolRequirement", "AutomationSolutionsStatus", "PriorityValue", "ReportedById", "AssignedToId", "CTSTransitioned", "KnowledgeTransfered", "BPHStatusValue", "ReportedSiteValue", "BPHRequirementTrackerTest", "DubaiValue", "SAMICValue", "SMMCValue", "GMMCValue", "RTCRSKValue", "RNIValue", "BMMCValue", "RTRValue", "RDPFValue", "LQDMexValue", "CMBMexPADValue", "JubailValue", "EBICValue", "PICValue", "Id", "ContentType", "Created", "ModifiedById", "Owshiddenversion", "Version", "Path", "SystemAllocation", "PrimarySolution", "FunctionalAreaModule", "RequirementStatusOLD", "FitAnalysis", "ProjectID", "CreatedBy", "TestDesignPriority", "BPHTrack", "Priority", "ReportedBy", "AssignedTo", "BPHStatus", "ReportedSite", "Dubai", "SAMIC", "SMMC", "GMMC", "RTCRSK", "RNI", "BMMC", "RTR", "RDPF", "LQDMex", "CMBMexPAD", "Jubail", "EBIC", "PIC", "ModifiedBy", "Attachments"}),
#"Reordered Columns" = Table.ReorderColumns(#"Kept Errors", {"Row Number", "ContentTypeID", "BPHRequirementID", "RequirementName", "RequirementStatusOLDValue", "BIReportNumber", "Comments", "FitAnalysisValue", "APQC", "ProjectIDValue", "Modified", "Capability", "CreatedById", "TrainingDocLink", "TestScriptLink", "TestDesignPriorityValue", "WorkInstruction", "TestScriptValidationDate", "ProcessFlow", "TrainingDoc", "BPHTrackValue", "RequirementDescription", "PCFID", "WaveIVProjectReviewed", "RFC", "AutoSolRequirement", "AutomationSolutionsStatus", "PriorityValue", "ReportedById", "AssignedToId", "CTSTransitioned", "KnowledgeTransfered", "BPHStatusValue", "ReportedSiteValue", "BPHRequirementTrackerTest", "DubaiValue", "SAMICValue", "SMMCValue", "GMMCValue", "RTCRSKValue", "RNIValue", "BMMCValue", "RTRValue", "RDPFValue", "LQDMexValue", "CMBMexPADValue", "JubailValue", "EBICValue", "PICValue", "Id", "ContentType", "Created", "ModifiedById", "Owshiddenversion", "Version", "Path", "SystemAllocation", "PrimarySolution", "FunctionalAreaModule", "RequirementStatusOLD", "FitAnalysis", "ProjectID", "CreatedBy", "TestDesignPriority", "BPHTrack", "Priority", "ReportedBy", "AssignedTo", "BPHStatus", "ReportedSite", "Dubai", "SAMIC", "SMMC", "GMMC", "RTCRSK", "RNI", "BMMC", "RTR", "RDPF", "LQDMex", "CMBMexPAD", "Jubail", "EBIC", "PIC", "ModifiedBy", "Attachments"})
in
  #"Reordered Columns"

[dax]

Hi sudanaditya, 

I copy and paste your code in my enviornment, there is no syntax error prompt. You said you get error when you excute the code and you got the error in advanced editor, right? You could try to click the error in advanced editor to see the detailed error information and inform me. Then I will help you more correctly.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sudanaditya]

Thanks Zoe .

The scenario is we are importing data from share point list which has 3300 Records . When I establish the connection in Power BI and Load it in the import stops at 2810 Record with the error which I have take from the advance editior  and posted it here. Every time I refresh , the refresh stops at the same point . This is the over all problem. Do let me know if you need more information or we can an web ex if you can let me know when you will be availble.