Optimize Power BI semantic models with star schemas, DAX measures, and RLS.
npx skills add https://github.com/miptah21/skills --skill powerbi-modeling-miptah21
Please help me install this Agent Skill. Skill: powerbi-modeling Source: https://github.com/miptah21/skills/tree/main/.agents/skills/powerbi-modeling Command: npx skills add https://github.com/miptah21/skills --skill powerbi-modeling-miptah21
This Skill helps you build optimized Power BI semantic models by guiding the correct structure for tables, relationships, DAX measures, security, documentation, and performance tuning.
Use the powerbi-modeling skill to connect to your current Power BI semantic model and then diagnose and improve your star schema, relationship settings, and key DAX measures for performance and maintainability.
High-intent search queries and answers about installing and using this skill.
To structure a star schema in Power BI and resolve ambiguous filter paths, design dimension and fact tables with single-direction relationships. This ensures predictable filter behavior and prevents circular filtering issues.
The best way to implement row-level security (RLS) in Power BI is by applying security filters to dimension tables rather than fact tables. This approach maintains model performance and ensures correct filter propagation.
To tune Power BI DAX performance for DirectQuery models, reduce unnecessary columns and rows, avoid inefficient DAX patterns that degrade query speed, and validate cardinality and cross-filter direction settings.
Yes, you can validate your Power BI semantic model against best practices by connecting to the active model, enumerating model objects, and evaluating relationship health, DAX measure quality, and star schema structure.
Power BI data models experience slow query performance due to high cardinality columns, bidirectional cross-filters, and inefficient DAX measures. Resolving these issues requires model validation and performance tuning.
jaimedhenriquesAnalyze Power BI semantic models for design, DAX, and relationship issues.
githubGuide Power BI semantic model design, DAX measures, and performance optimization.
PatrickGallucciDiagnose and remediate Fabric Power BI security and access issues.
data-goblinAutomate Tabular Editor CLI deployments, BPA analysis, and script execution for semantic models.
