Azure Data Factory Data Flow - Oddity of the week

This week, I stumbled into an interesting puzzle while investigating an issue for a client. They had recently transitioned from System A to System B, and one of their critical metrics suddenly showed significant discrepancies. Business-wise, these numbers were expected to remain identical, so naturally, it called for some digging. I started by checking the basics: Source API: Was the new system feeding incorrect data? No issues there. Transformed Reporting Tables: Were calculations or transformations misconfigured? Again, everything seemed correct. ...