Error Messages

Your problem is in the Payroll Tracker Entity Level:

= Table.TransformColumnTypes(#"Promoted Headers",{{"Entity", type text}, {"Business Unit", type text}, {"DEPTID", Int64.Type}, {"DEPTNAME", type text}, {"VP ID", Int64.Type}, {"VP Name", type text}, {"Email", type text}, {"DIRECTOR_EMPLID", Int64.Type}, {"DIRECTOR_NAME", type text}, {"DIR_EMAIL_ADDR", type text}, {"MGR ID", Int64.Type}, {"Manager", type text}, {"MGR Email", type text}, {"Employee ID", Int64.Type}, {"NAME", type text}, {"Jobcode", type text}, {"Jobtitle", type text}, {"HOURLY_RT", type number}, {"COMP_FREQUENCY", type text}, {"FLSA_STATUS", type text}, {"FULL_PART_TIME", type text}, {"FTE", type number}, {"Goal Hour", type number}, {"Add_Email_1", Int64.Type}, {"Add_Email_2", type text}, {"AE_EMAIL1", type text}, {"AE_EMAIL2", type text}, {"AE_EMAIL3", type text}, {"AE_EMAIL4", type text}, {"AE_EMAIL5", type text}, {"AE_EMAIL6", type text}, {"AE_EMAIL7", type text}, {"Dustin_Email", type text}, {"Trallyn_Email", type text}, {"Hours Used", type number}, {"Hours Used Earnings", Currency.Type}, {"Hours Used Capped", type number}, {"Scheduled Hours", Int64.Type}, {"Scheduled Hours Capped", Int64.Type}, {"Scheduled Hours Earnings", Currency.Type}, {"LWOP Earnings", Currency.Type}, {"Vacation Accrued", type number}, {"Holiday Accrued", type number}, {"Personal Holiday Accrued", type number}, {"Hours to Goal", type number}, {"Hours Worked", type number}})

Your Add_Email_1 column is being converted to an integer. That is the error.