Forum Discussion
Mensajes de error
Hola a todos, Tengo 3 tablas en mi modelo de datos, todas tienen la misma fuente. Lo tengo 3 veces por razones de seguridad. Por alguna razón sigo recibiendo este mensaje de error que hay...
edhans
Community Champion
Community Champion¿Editar qué fuente? No estoy seguro de a qué te refieres. La columna de correo electrónico debe ser texto, no número. En cuanto a XLS vs XLSX, necesita su sistema de origen para exportar en XLS o necesita convertirse a sí mismo. THere hay macros disponibles para automatizar ese tipo de cosas o scripts de Power Automate si los datos se almacenan en un sitio de SharePoint.
edhansCommunity Champion
Community ChampionSu problema está en el nivel de entidad de seguimiento de nómina:
= 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}})La columna Add_Email_1 se está convirtiendo en un entero. Ese es el error.