Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
edhans's avatar
edhans
Community Champion
6 years ago

Yup. Data type issue. You are trying somewhere to convert an email address into a number.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

So do I need to edit the source file in some way to prevent this from happening?

  • edhans's avatar
    edhans
    Community Champion
    6 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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?

    • edhans's avatar
      edhans
      Community Champion
      6 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I see what you mean, just fixed it! Works great now