Forum Discussion

FatiFlaubert's avatar
FatiFlaubert
Helper I
5 years ago

Error in Data

Hi,  Please I got this error when I try to refresh data. Anyone could tell me what doest it mean and what should I do ?  Thank you in advance,  
Need Help
  • FatiFlaubert's avatar
    FatiFlaubert
    Helper I
    5 years ago

    = Table.ReorderColumns(#"Kept Errors", {"Row Number", "Date", "Market", "Team", "Medical Delegate Name", "Pediatricians Calls", "Nurses Calls", "Midwives Calls", "Pharma Calls", "Other Calls", "Medical Calls", "Total Calls", "Ped Calls %", "Nurse Calls %", "MW Calls %", "Pharma Calls %", "Other Calls %", "Med Calls %", "F2F Calls %", "Remote Calls %", "Working Days", "Call Rate", "Call Sub Time in Days", "A", "B", "% A", "% B", "Avg A freq", "Avg B freq", "Coaching sessions", "A ML", "B ML", "A Covered", "B Covered", "Column34", "Column35", "Column36", "Column37", "Target Calls", "Call Rate Pharma"})

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      5 years ago

      Hi FatiFlaubert 

      I don't see any error in this query from your screenshot. This step is to reorder the columns in the table. It doesn't seem to cause any error. 

      The only error shown in the picture is Errors in Data (10) query, can you click on that query and check the specific error message in it?

       

      Regards,
      Community Support Team _ Jing