Power BI Semantic Model Skill

This skill provides guidance on how to develop Power BI semantic models.

References

• modeling-guidelines: General best practices for modeling, including star schema design, naming conventions, and DAX measure patterns.
• direct-lake-guidelines: Specific guidelines for working with Direct Lake semantic models, including partition source types and limitations.
• TMDL: Reference for TMDL syntax and properties when working with TMDL code and files.
• pbip.md: Guidelines for working with Power BI Project files (PBIP) that contain semantic models.
• dax-udf-functions-guidelines: Guidelines for creating and using DAX User-Defined Functions (UDFs) to centralize business logic in the model.
• dax-query-guidelines: Guidelines for writing DAX queries against the semantic model for validation and analysis.
• dax-performance-optimization: Guidelines for DAX performance optimization, including storage engine vs. formula engine analysis, anti-pattern detection, and optimization strategies.

IMPORTANT

• Respect the Tool Selection Priority.
• If asked to work with TMDL code or *.tmdl files, load the TMDL reference to understand the syntax and properties of TMDL objects.
• If asked to export or save the semantic model to a PBIP project, make sure you understand the PBIP explained in references/pbip.md.