powerbi-modeling

Power BI star schema design requires classifying tables as dimensions and facts to ensure a consistent grain. This skill provides structured best practices to optimize your table structures and establish a solid semantic model foundation.

Configuring Power BI relationships and RLS requires setting correct cardinality, cross-filter direction, and security roles. This skill provides expert guidance to create robust data models and validate your row-level security implementation.

Yes, you can run a Power BI model health check to diagnose performance inefficiencies and undocumented DAX measures. This skill analyzes your active model to deliver a prioritized improvement plan referencing DAX and performance best practices.

Yes, you need an active MCP server connection to your Power BI model. This skill requires access to the live model via MCP tools to evaluate semantic structures, relationships, and security configurations before generating improvement recommendations.

The best way to refactor and document a Power BI data model is through a structured health check. This skill references specific guidance documents to review measures, validate relationships, and ensure meaningful naming conventions during your refactoring workflow.

Power BI models suffer from performance inefficiencies when semantic designs are inconsistent and measures are undocumented. This skill diagnoses your active model and provides structured steps to build optimized, well-documented data models.