There is a need to perform audit on master data periodically against pre-determined audit rules. The audit will report data issues in our master data to the data stewards. The data stewards will perform the necessary data clean up activity to make sure the data is in good quality for consumption.

This guide should serve as a reference to report owner to troubleshoot issues, and/or modify audit rules in the Power Query if needed.