Eliminate Guesswork, Modify with Confidence 🚀
Have you ever needed to delete a field but were afraid of breaking a hidden form, view, or flow? Have you ever wondered which fields on a table are actually being used by your team and which are just clutter?
The Data Completeness & Dependency Analyzer is a powerful two-in-one tool designed to answer these critical questions. It provides a clear, quantitative report on your data quality and exposes every hidden dependency, empowering you to manage your Dataverse environment with confidence.
Key Features
Field Population Analysis
Calculates the exact percentage of records where each field is populated, giving you a clear view of data quality and user adoption.
Comprehensive Dependencies
Select any field and instantly find every component that depends on it, including forms, views, workflows, plugins, and relationships.
Powerful Filtering
Quickly find fields by name, and filter the report to show only fields below a certain completeness percentage (e.g., show all fields less than 50% full).
Export to CSV
Export the entire field completeness report to a CSV file with one click, perfect for documentation, data audits, or sharing with your team.
Quick GUID Copy
Simply double-click any item in the dependency list to instantly copy its GUID to your clipboard for use elsewhere.
Optimized Performance
Uses efficient FetchXML aggregates and batch metadata requests to quickly analyze large tables without freezing or slowing down.
How It Works
- Connect: Open XrmToolBox and connect to your Dataverse environment.
- Select and Analyze: Choose a table from the dropdown list and click the "Analyze Table" button.
- Review Completeness: The main grid will populate, showing every field and its data completeness percentage. Use the filters at the top to narrow your search.
- Check Dependencies: Select a single field in the grid and click "Get Dependencies." The right-hand panel will show every component that references that field.
- Export or Copy: Click "Export" to save the completeness report, or double-click a dependency to copy its GUID.
Why You Need This Tool
- Safe Field Deprecation: Confidently identify and remove unused fields (0% completeness, no dependencies) to clean up your forms and simplify your data model.
- Data Migration Planning: Before a migration, determine which fields contain essential data and which can be safely ignored, saving significant time and effort.
- Data Quality Audits: Quickly spot important fields that users are failing to fill out, identifying gaps in training or business processes.
- Impact Analysis: Before changing a field's data type or modifying an option set, see every part of the system that will be affected to prevent unexpected errors.
- System Documentation: Export completeness reports on a schedule to track data quality over time and document the state of your most important tables.
Get The Tool
The Data Completeness & Dependency Analyzer is available for free in the XrmToolBox Plugin Store. Simply open XrmToolBox, navigate to the Plugin Store, and search for the plugin by name to install it.
Open in XrmToolBox Plugin Store