Forum Discussion
Error Messages
Yup. Data type issue. You are trying somewhere to convert an email address into a number.
By the way Anonymous , you should edit your post above and remove those links. There is confidential data in here.
You are right my bad, I though these were my test files
One final note (assuming this is resolved) I could not for the life of me get this to work with the April 2020 desktop update. The XLS file format was causing a big problem. I converted to XLSX and it worked fine. You should consider doing the same. It might be I don't have the Access 2010 distributable installed, which is required for some XLS stuff. And it could be MS isn't testing as much with XLS.
There are known bugs with XLS files and Power BI and MS has no intention to fix them.
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?