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 on only 1 of the tables and not the other 2, even though the source is the exact same excel sheet.
When I click to view errors, I don't see any errors.
Any help would be appreciated
18 Replies
Anonymous , Open Edit Query/ Data Transformation from home Tab. There you will see error in yellow
Hi Anonymous ,
Check the values before convert them.
The columns:
Scheduled Hours Earnings,
Hours Used Earnings,
LWOP Earnings
have the character $, first remove it and change the datatype to numerical type.
Also the column Add_Email_1 is as numeric, it has text values.
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.
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.
