Forum Discussion

LMSReportsHelp's avatar
LMSReportsHelp
Frequent Visitor
2 years ago
Solved

Fix type mismatch by replacing data?

I have a report coming out of a system on a nightly feed and updating my Power BI data.  For some reason, on a specific day and single specific user's records are in the wrong format.  Everything else in the column shows as a time (0:01:00) but for some reason his records on ONE DAY is in decimal format (0.025694444). This column isn't super important to our data, but my first choice is to "fix."  I am going to the system administrator to have them look into WHY this is in the reporting at all.  In the meantime, it's constantly throwing errors at me.

 

I know I can use "Remove errors" to remove them.  I can't just "modify the source" because it will just get overwritten tonight in the feed from the system.  I would rather just set him to "0:00:00" than remove the records but when I tried to use "find and replace" it wouldn't let me put in a decimal at all, it says I must enter a time (you know, because the column is a time-record).  

 

Do I have any way I can replace this value without going the "modify the source" route (until I can fix the root report getting fed to me)?

  • In Power Query, there is a 'Replace Errors' feature. Have you tried that?

1 Reply

  • HotChilli's avatar
    HotChilli
    Community Champion

    In Power Query, there is a 'Replace Errors' feature. Have you tried that?