Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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)?
Solved! Go to Solution.
In Power Query, there is a 'Replace Errors' feature. Have you tried that?
In Power Query, there is a 'Replace Errors' feature. Have you tried that?
User | Count |
---|---|
89 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
96 | |
92 | |
91 | |
75 | |
69 |