Error in Data

[FatiFlaubert]

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,

[amitchandak]

@FatiFlaubert ,

can you click on one of the errors and share that?

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

[FatiFlaubert]

= 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]

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