Identify data anomalies Power Query provides different functionality for identifying data anomalies depending on what…