Forum Discussion
Error Messages
Hello All, I have 3 tables in my data model, all have the same source. I have it 3 times for security reasons. For some reason I keep getting this error message that there are 72 errors o...
So do I need to edit the source file in some way to prevent this from happening?
Edit what source? Not sure what you are referring to. The email column should be text, not number. As for XLS vs XLSX, you need your source system to export in XLS or you need to convert yourself. THere are macros available to automate that kind of thing or Power Automate scripts if data is stored on a SharePoint site.
Sorry I meant do I need to edit the excel sheet in some way? Or this is a problem in need to fix in Power BI?
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.
I see what you mean, just fixed it! Works great now
Excellent Anonymous . Glad we tracked it down.