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

by the way, in order to really help, we'd need a PBIX file to look at, plus the source files as PQ will just show an error if the source isn't there.

  • 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.

     

    • edhans's avatar
      edhans
      Community Champion
      6 years ago

      By the way Anonymous , you should edit your post above and remove those links. There is confidential data in here.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        You are right my bad, I though these were my test files

    • 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.