Forum Discussion
Error Messages
A lot of time when I see errors like this but you cannot find them in the PQ window itself it is some sort of data mismatch with how the column is typed (date, whole number, etc.) vs what formulas or even DAX is expecting when it comes in.
It can be tedious to find sometimes.
- Anonymous6 years agoNot applicable
Right, it is just so odd that it is only erroring out on one of the tables and not the other two
- edhans6 years agoCommunity Champion
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.
- Anonymous6 years agoNot applicable
PBIX file:
https://www.dropbox.com/s/hzbagqtar9fl2ky/8%20in%208%20Reporting.pbix?dl=0
Source Excel File:
https://www.dropbox.com/s/90z2sm5xuyrv7so/PayrollTracker.xls?dl=0
- edhans6 years agoCommunity Champion
Yup. Data type issue. You are trying somewhere to convert an email address into a number.