Hi,
My scheduled refersh has failed due to the following error:
OLE DB or ODBC error: [Expression.Error] 'Table.Sort' requires at least one sort criterion..
My data is uploaded via serveral combined csv files in a sharepoint folder. There was an incorrect file within this which accaidentally got put in. I removed this from the folder but I am still getting the error when i refresh. I have gone into power query editor and found where the issue is but I am unsure how to resolve it. The advanced editor code is displayed below with the highlighted bit showing where the error is occuring. Any help on why this is occurring would be greatly appreciated.
let
Source = #"Sharepoint Folder - SS Data Storage DO NOT DELETE",
Source2 = Source,
#"2 GPS" = Source2{[Name="2. GPS"]}[Content],
#"Training Data" = #"2 GPS"{[Name="Training Data"]}[Content],
#"Filtered Hidden Files1" = Table.SelectRows(#"Training Data", each [Attributes]?[Hidden]? <> true),
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File (15)", each #"Transform File (15)"([Content])),
#"Removed Other Columns1" = Table.SelectColumns(#"Invoke Custom Function1", {"Transform File (15)"}),
#"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File (15)", Table.ColumnNames(#"Transform File (15)"(#"Sample File (15)"))),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Player Last Name", type text}, {"Drill Title", type text}, {"Session Date", type date}, {"Total Time", type time}, {"Drill Start Time", type time}, {"Drill End Time", type time}, {"Session Start Time", type time}, {"Session End Time", type time}, {"Player Name", type text}, {"Player Display Name", type text}, {"Player First Name", type text}, {"Total Distance", Int64.Type}, {"Distance Zone 4 (Absolute)", Int64.Type}, {"High Speed Running (Absolute)", Int64.Type}, {"Sprint Distance", Int64.Type}, {"Sprints", Int64.Type}, {"Max Speed", type number}, {"Average Speed", type number}, {"Speed Intensity", type number}, {"Accelerations Zone 4 - Zone 6", Int64.Type}, {"Decelerations Zone 4 - Zone 6", Int64.Type}, {"HML Distance", Int64.Type}, {"Explosive Distance (Absolute)", Int64.Type}, {"HML Efforts", Int64.Type}, {"Total Loading", type number}, {"HML Efforts Total Distance", Int64.Type}, {"Dynamic Stress Load", type number}, {"Fatigue Index", type number}, {"ED/min", type number}, {"Max Heart Rate", Int64.Type}, {"Average Heart Rate", type number}, {"Heart Rate Exertion", type number}, {"Time In Red Zone", type time}, {"Distance Per Min", type number}, {"HSR Per Minute (Absolute)", type number}, {"HMLD Per Minute", type number}, {"DSL/min", type number}, {"Total Right Steps", Int64.Type}, {"Accelerations", Int64.Type}, {"Accelerations Zone 3 - Zone 6", Int64.Type}, {"Accelerations Zone 5 - Zone 6", Int64.Type}, {"Accelerations Zone 1", Int64.Type}, {"Accelerations Zone 2", Int64.Type}, {"Accelerations Zone 3", Int64.Type}, {"Accelerations Zone 4", Int64.Type}, {"Accelerations Zone 5", Int64.Type}, {"Accelerations Zone 6", Int64.Type}, {"Average Metabolic Power", type number}, {"HML Efforts Maximum Speed", type number}, {"Decelerations Zone 3 - Zone 6", Int64.Type}, {"Decelerations Zone 5 - Zone 6", Int64.Type}, {"Decelerations", Int64.Type}, {"Decelerations Zone 1", Int64.Type}, {"Decelerations Zone 2", Int64.Type}, {"Decelerations Zone 3", Int64.Type}, {"Decelerations Zone 4", Int64.Type}, {"Decelerations Zone 5", Int64.Type}, {"Decelerations Zone 6", Int64.Type}, {"Distance Zone 1 (Absolute)", Int64.Type}, {"Distance Zone 2 (Absolute)", Int64.Type}, {"Distance Zone 3 (Absolute)", Int64.Type}, {"Distance Zone 3 - Zone 6 (Absolute)", Int64.Type}, {"Distance Zone 4 - Zone 6 (Relative)", Int64.Type}, {"Distance Zone 5 (Absolute)", Int64.Type}, {"Average Time Since Last HML Effort", type time}, {"Drill Date", type date}, {"Player Custom ID", type any}, {"Duration Of High Intensity Bursts", type time}, {"Dynamic Load Anterior", type number}, {"Dynamic Load Lateral", type number}, {"Dynamic Load Vertical", type number}, {"Dynamic Stress Load Zone 1", type number}, {"Dynamic Stress Load Zone 2", type number}, {"Dynamic Stress Load Zone 3", type number}, {"Dynamic Stress Load Zone 4", type number}, {"Dynamic Stress Load Zone 5", type number}, {"Dynamic Stress Load Zone 6", type number}, {"Metabolic Distance", Int64.Type}, {"Impacts", Int64.Type}, {"Impacts Zone 3 - Zone 6", Int64.Type}, {"Impacts Zone 4 - Zone 6", Int64.Type}, {"Impacts Zone 5 - Zone 6", Int64.Type}, {"Impacts Zone 1", Int64.Type}, {"Impacts Zone 2", Int64.Type}, {"Impacts Zone 3", Int64.Type}, {"Impacts Zone 4", Int64.Type}, {"Impacts Zone 5", Int64.Type}, {"Impacts Zone 6", Int64.Type}, {"Total Metabolic Power", type number}, {"Left Anterior Post Impact", type number}, {"Left Average Vertical Impact", type number}, {"Left Lateral Impact", type number}, {"Left Mag Impact", type number}, {"Left Vertical Impact", type number}, {"Number Of High Intensity Bursts", Int64.Type}, {"Accelerations Total Distance Zone 1", Int64.Type}, {"Accelerations Total Distance Zone 2", Int64.Type}, {"Accelerations Total Distance Zone 3", Int64.Type}, {"Accelerations Total Distance Zone 4", Int64.Type}, {"Accelerations Total Distance Zone 5", Int64.Type}, {"Accelerations Total Distance Zone 6", Int64.Type}, {"Acceleration Impulse", type number}, {"Accelerations Total Time Zone 1", type time}, {"Accelerations Total Time Zone 2", type time}, {"Accelerations Total Time Zone 3", type time}, {"Accelerations Total Time Zone 4", type time}, {"Accelerations Total Time Zone 5", type time}, {"Accelerations Total Time Zone 6", type time}, {"Acute Chronic Ratio", Int64.Type}, {"Acute", Int64.Type}, {"Chronic", Int64.Type}, {"Player Date of Birth", type date}, {"Decelerations Total Distance Zone 1", Int64.Type}, {"Decelerations Total Distance Zone 2", Int64.Type}, {"Decelerations Total Distance Zone 3", Int64.Type}, {"Decelerations Total Distance Zone 4", Int64.Type}, {"Decelerations Total Distance Zone 5", Int64.Type}, {"Decelerations Total Distance Zone 6", Int64.Type}, {"Decelerations Total Time Zone 1", type time}, {"Decelerations Total Time Zone 2", type time}, {"Decelerations Total Time Zone 3", type time}, {"Decelerations Total Time Zone 4", type time}, {"Decelerations Total Time Zone 5", type time}, {"Decelerations Total Time Zone 6", type time}, {"Distance Zone 2 - Zone 6 (Relative)", Int64.Type}, {"Distance Zone 2 - Zone 6 (Absolute)", Int64.Type}, {"Distance Zone 3 - Zone 6 (Relative)", Int64.Type}, {"Distance Zone 4 - Zone 6 (Absolute)", Int64.Type}, {"Dives", Int64.Type}, {"Dives Left", Int64.Type}, {"Average GK Power", Int64.Type}, {"Dives Right", Int64.Type}, {"GK Load", type number}, {"Lower Speed Loading", type number}, {"Dynamic Stress Load Time Zone 1", type time}, {"Dynamic Stress Load Time Zone 2", type time}, {"Dynamic Stress Load Time Zone 3", type time}, {"Dynamic Stress Load Time Zone 4", type time}, {"Dynamic Stress Load Time Zone 5", type time}, {"Dynamic Stress Load Time Zone 6", type time}, {"Distance Zone 1 (Relative)", Int64.Type}, {"Distance Zone 2 (Relative)", Int64.Type}, {"Distance Zone 3 (Relative)", Int64.Type}, {"Distance Zone 4 (Relative)", Int64.Type}, {"Distance Zone 5 (Relative)", Int64.Type}, {"Distance Zone 6 (Absolute)", Int64.Type}, {"Distance Zone 6 (Relative)", Int64.Type}, {"Energy Expenditure (Kcal)", type number}, {"Equivalent Metabolic Distance", Int64.Type}, {"Entries Zone 3 (Absolute)", Int64.Type}, {"Entries Zone 3 (Relative)", Int64.Type}, {"Entries Zone 4 (Absolute)", Int64.Type}, {"Entries Zone 4 (Relative)", Int64.Type}, {"Entries Zone 5 (Absolute)", Int64.Type}, {"Entries Zone 5 (Relative)", Int64.Type}, {"Entries Zone 6 (Absolute)", Int64.Type}, {"Entries Zone 6 (Relative)", Int64.Type}, {"Explosive Distance (Relative)", Int64.Type}, {"External Work", type number}, {"Player Height", type number}, {"High Intensity Bursts Total Distance", Int64.Type}, {"High Intensity Bursts Maximum Speed", type number}, {"HML Time", type time}, {"Heart Rate Load", type number}, {"Average Dive Impact", type number}, {"Ball In Play Time", type time}, {"Ball In Play Time %", Int64.Type}, {"High Speed Running (Relative)", Int64.Type}, {"HSR Per Minute (Relative)", type number}, {"Max Deceleration", type number}, {"Player Max Heart Rate", Int64.Type}, {"Player Max Speed", type number}, {"Metabolic Distance Zone 1", Int64.Type}, {"Metabolic Distance Zone 2", Int64.Type}, {"Metabolic Distance Zone 3", Int64.Type}, {"Metabolic Distance Zone 4", Int64.Type}, {"Metabolic Distance Zone 5", Int64.Type}, {"Metabolic Distance Zone 6", Int64.Type}, {"Metabolic Time Zone 1", type time}, {"Metabolic Time Zone 2", type time}, {"Metabolic Time Zone 3", type time}, {"Metabolic Time Zone 4", type time}, {"Metabolic Time Zone 5", type time}, {"Metabolic Time Zone 6", type time}, {"Max Acceleration", type number}, {"Player Primary Position", type text}, {"Right Anterior Post Impact", type number}, {"Right Average Vertical Impact", type number}, {"Player Resting Heart Rate", Int64.Type}, {"Right Lateral Impact", type number}, {"Right Mag Impact", type number}, {"Right Vertical Impact", type number}, {"Step Balance", type number}, {"Session Day of Week", type text}, {"Session Title", type text}, {"Session Type", type text}, {"Speed Intensity Zone 1 (Absolute)", type number}, {"Speed Intensity Zone 1(Relative)", type number}, {"Speed Intensity Zone 2 (Absolute)", type number}, {"Speed Intensity Zone 2 (Relative)", type number}, {"Speed Intensity Zone 3 (Absolute)", type number}, {"Speed Intensity Zone 3 (Relative)", type number}, {"Speed Intensity Zone 3 - Zone 6 (Absolute)", type number}, {"Speed Intensity Zone 3 - Zone 6 (Relative)", type number}, {"Speed Intensity Zone 4 (Absolute)", type number}, {"Speed Intensity Zone 4 (Relative)", type number}, {"Speed Intensity Zone 4 - Zone 6 (Absolute)", type number}, {"Speed Intensity Zone 4 - Zone 6 (Relative)", type number}, {"Speed Intensity Zone 5 (Absolute)", type number}, {"Speed Intensity Zone 5 (Relative)", type number}, {"Speed Intensity Zone 5 - Zone 6 (Absolute)", type number}, {"Speed Intensity Zone 5 - Zone 6 (Relative)", type number}, {"Speed Intensity Zone 6 (Absolute)", type number}, {"Speed Intensity Zone 6 (Relative)", type number}, {"Player Sprint Threshold", type number}, {"Session Week Number", Int64.Type}, {"Total Acceleration Loading", type number}, {"Total Deceleration Loading", type number}, {"Time In Heart Rate Zone 1", type time}, {"Time In Heart Rate Zone 2", type time}, {"Time In Heart Rate Zone 2 - Zone 6", type time}, {"Time In Heart Rate Zone 3", type time}, {"Time In Heart Rate Zone 3 - Zone 6", type time}, {"Time In Heart Rate Zone 4", type time}, {"Time In Heart Rate Zone 4 - Zone 6", type time}, {"Time In Heart Rate Zone 5", type time}, {"Time In Heart Rate Zone 6", type time}, {"Total Left Steps", Int64.Type}, {"% Time In Red Zone", type number}, {"Average Time Since Last Accel", type time}, {"Average Time Since Last Decel", type time}, {"Average Time Since Last Dive", type time}, {"Average Time Since Last HIB", type time}, {"Average Time Since Last Sprint", type time}, {"Time Zone 1 (Absolute)", type time}, {"Time Zone 1 (Relative)", type time}, {"Time Zone 2 (Absolute)", type time}, {"Time Zone 2 (Relative)", type time}, {"Time Zone 3 (Absolute)", type time}, {"Time Zone 3 (Relative)", type time}, {"Time Zone 4 (Absolute)", type time}, {"Time Zone 4 (Relative)", type time}, {"Time Zone 5 (Absolute)", type time}, {"Time Zone 5 (Relative)", type time}, {"Time Zone 6 (Absolute)", type time}, {"Time Zone 6 (Relative)", type time}, {"Player Weight", type number}, {"SI/min", type number}, {"SPR/min", type number}, {"ACC/min", type number}, {"Dec/min", type number}, {"Dynamic Stress Load Zone 3 - Zone 6", type number}, {"Dynamic Stress Load Zone 4 - Zone 6", type number}, {"Dynamic Stress Load Zone 5 - Zone 6", type number}, {"Metabolic Time", type time}, {"No of Satellites", Int64.Type}, {"Quality of Signal", Int64.Type}}),
#"Sorted Rows" = Table.Sort(#"Expanded Table Column1",{{"Session Date", Order.Ascending}}),
#"Appended Query" = Table.Combine({#"Sorted Rows", #"NI INT Data"}),
#"Removed Other Columns" = Table.SelectColumns(#"Appended Query",{"Player Last Name", "Drill Title", "Session Date", "Total Time", "Drill Start Time", "Drill End Time", "Session Start Time", "Session End Time", "Player Name", "Player Display Name", "Player First Name", "Total Distance", "Distance Zone 4 (Absolute)", "High Speed Running (Absolute)", "Sprint Distance", "Sprints", "Max Speed", "Average Speed", "Speed Intensity", "Accelerations Zone 4 - Zone 6", "Decelerations Zone 4 - Zone 6", "HML Distance", "Explosive Distance (Absolute)", "HML Efforts", "Total Loading", "HML Efforts Total Distance", "Dynamic Stress Load", "Fatigue Index", "ED/min", "Max Heart Rate", "Average Heart Rate", "Heart Rate Exertion", "Time In Red Zone", "Distance Per Min", "HSR Per Minute (Absolute)", "HMLD Per Minute", "DSL/min", "Total Right Steps", "Accelerations", "Accelerations Zone 5 - Zone 6", "Average Metabolic Power", "HML Efforts Maximum Speed", "Decelerations Zone 5 - Zone 6", "Decelerations", "Distance Zone 1 (Absolute)", "Distance Zone 2 (Absolute)", "Distance Zone 3 (Absolute)", "Distance Zone 3 - Zone 6 (Absolute)", "Distance Zone 5 (Absolute)", "Duration Of High Intensity Bursts", "Metabolic Distance", "Total Metabolic Power", "Left Anterior Post Impact", "Left Average Vertical Impact", "Left Lateral Impact", "Left Mag Impact", "Left Vertical Impact", "Acceleration Impulse", "Distance Zone 2 - Zone 6 (Absolute)", "Distance Zone 4 - Zone 6 (Absolute)", "Dives", "Dives Left", "Average GK Power", "Dives Right", "GK Load", "Distance Zone 6 (Absolute)", "Equivalent Metabolic Distance", "Entries Zone 5 (Absolute)", "Entries Zone 6 (Absolute)", "High Intensity Bursts Total Distance", "High Intensity Bursts Maximum Speed", "HML Time", "Heart Rate Load", "Average Dive Impact", "Max Deceleration", "Player Max Heart Rate", "Max Acceleration", "Player Primary Position", "Right Anterior Post Impact", "Right Average Vertical Impact", "Right Lateral Impact", "Right Mag Impact", "Right Vertical Impact", "Step Balance", "Session Day of Week", "Session Title", "Session Type", "Total Acceleration Loading", "Total Deceleration Loading", "% Time In Red Zone", "SI/min", "SPR/min", "ACC/min", "Dec/min"}),
