skills.rest
patrikborosch
patrikboroschCOMMUNITY
Explore all skills by this author →
GitHub

semantic-model-authoring

Develop and manage Power BI semantic models across Desktop, PBIP, and Fabric.

14|3|Updated Mar 13, 2026
Search Tags:#data modeling#star schema#power bi#semantic model#dax optimization#pbip#fabric workspace
One-click install
npx skills add https://github.com/patrikborosch/AnalyticsPlatformAgents --skill semantic-model-authoring-patrikborosch
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: semantic-model-authoring
Source: https://github.com/patrikborosch/AnalyticsPlatformAgents/tree/main/creator/skills/semantic-model-authoring
Command: npx skills add https://github.com/patrikborosch/AnalyticsPlatformAgents --skill semantic-model-authoring-patrikborosch

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill eliminates the manual, error-prone work of building and maintaining Power BI semantic models across Desktop, PBIP projects, and Microsoft Fabric Service, ensuring consistent star schema design, performant DAX, and reliable deployments without relying on fragmented manual TMDL edits.

Core Features & Use Cases

  • Full model lifecycle authoring: Create new semantic models from scratch, edit existing objects (tables, columns, measures, relationships), and deploy to Fabric workspaces or export to PBIP projects.
  • Performance & quality assurance: Diagnose slow DAX queries with trace-based optimization frameworks, audit models against best practices for naming, star schema conformance, and data type efficiency.
  • AI readiness & operational management: Prepare models for Copilot/Data Agents, configure data sources, permissions, refreshes, and connection bindings for cross-environment promotion. Use case: A BI developer building a sales analytics model for Fabric can use this Skill to design a star schema, add optimized DAX measures, fix performance bottlenecks in YTD calculations, and deploy the model to a production workspace with correct gateway bindings.

Quick Start

Use the semantic-model-authoring skill to create a new Direct Lake semantic model for the Contoso Sales table in the Development workspace and deploy it to the Production workspace after validation.

Frequently Asked Questions about semantic-model-authoring

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a Power BI semantic model using a star schema design?▼

To build a Power BI semantic model, you create new models from scratch by defining tables, columns, measures, and relationships while enforcing star schema and naming conventions for reliable structure.

Can I edit existing Power BI semantic model objects like measures and relationships?▼

Yes, you can edit existing model objects including tables, columns, measures, and relationships directly within Power BI Desktop, PBIP projects, or Fabric Service workspaces for full lifecycle management.

What is the best way to diagnose and optimize slow DAX queries in a semantic model?▼

The best way to optimize slow DAX queries is using trace-based optimization frameworks to diagnose performance bottlenecks and apply best practices for data type efficiency and calculation refinement.

Does this semantic model authoring process support Direct Lake storage mode in Fabric?▼

Yes, semantic model authoring supports Import, DirectQuery, and Direct Lake storage modes, allowing you to configure connections and manage deployments across different Fabric Service environments.

How do I prepare a Power BI semantic model for AI and Copilot consumption?▼

You prepare models for AI and Copilot consumption by auditing them against best practices, ensuring proper naming conventions, and configuring data sources and permissions for optimal data agent readiness.

How do I manage deployments and data source permissions for Power BI semantic models?▼

You manage deployments by using Fabric REST APIs and TMDL editing to configure data sources, permissions, refreshes, and gateway bindings for reliable cross-environment promotion to production workspaces.

Related Skills

Explore More Data & Analytics Skills→
rritecrritec
3

semantic-model-authoring

Create, edit, deploy, and validate Power BI semantic models.

Community
Advanced
patrikboroschpatrikborosch
14

fabriciq

Answer natural language questions about Power BI report data via FabricIQ.

Community
Advanced
microsoftmicrosoft
952

semantic-model-authoring

Create, edit, and deploy Power BI semantic models across Fabric workspaces and PBIP projects.

Official
Advanced
GabeujinGabeujin

power-bi-performance-troubleshooting

Diagnose and resolve performance bottlenecks in Power BI models, reports, and queries.

Community
Advanced