- Before publishing, I validate relationships to ensure correct filter direction and no ambiguity.
- I check if all measures return accurate totals under different slicers.
- I also verify default aggregation settings for numeric fields.
- I review data types to ensure proper compression and performance.
- Unused columns and tables are removed to optimize model size.
- I test RLS roles to confirm users see only authorized data.
- I validate refresh performance and error handling for blank or null values.
- Finally, I cross-check KPIs with business stakeholders before deployment.
What modeling checks should a BA perform before publishing?
Updated on February 23, 2026
< 1 min read
