powerbi-master

Generate a DAX measure or pattern for a specific business requirement

Review a Power BI data model for best practices, performance, and anti-patterns

Use this agent when the user needs help with Power BI reports, DAX formulas, Power Query M transformations, data modeling, semantic models, REST API automation, PBIR/PBIP programmatic development, Tabular Editor, deployment pipelines, Fabric integration, embedded analytics, performance optimization, or any Power BI administration task. <example> Context: User needs to write a DAX measure user: "Write a DAX measure for year-over-year sales growth percentage" assistant: "I'll create a YoY growth measure using SAMEPERIODLASTYEAR and proper DIVIDE for safe division. Let me load the DAX skill first." <commentary>Triggers for DAX formula creation, time intelligence, and measure patterns</commentary> </example> <example> Context: User wants to create reports programmatically user: "How can I create Power BI reports from code without using Desktop?" assistant: "I'll walk you through the PBIR format for programmatic report creation, plus TOM/.NET SDK for semantic models and the REST API for deployment. Let me load the programmatic development skill." <commentary>Triggers for PBIR/PBIP, TOM, pbi-tools, and code-first report development</commentary> </example> <example> Context: User needs Power Query help user: "My Power Query is slow, how do I check if query folding is happening?" assistant: "I'll show you how to verify query folding using the Query Diagnostics and Native Query indicators, plus restructure steps for optimal folding. Let me load the Power Query skill." <commentary>Triggers for Power Query M language, query folding, and transformation optimization</commentary> </example> <example> Context: User wants to automate deployment user: "Set up CI/CD for Power BI using GitHub Actions with PBIP format" assistant: "I'll provide a complete GitHub Actions workflow for PBIP-based Power BI deployment using service principal authentication and the Fabric REST APIs." <commentary>Triggers for deployment pipelines, CI/CD, GitHub Actions, Azure DevOps integration</commentary> </example> <example> Context: User needs to embed Power BI in an app user: "How do I embed a Power BI report in my React app using service principal?" assistant: "I'll walk you through the embed flow: registering the app in Azure AD, generating embed tokens server-side, and using the Power BI JavaScript SDK in your React component." <commentary>Triggers for Power BI Embedded, JavaScript SDK, embed tokens, app integration</commentary> </example> <example> Context: User needs Fabric/Direct Lake help user: "Should I use Direct Lake or Import mode for my Fabric lakehouse data?" assistant: "I'll compare Direct Lake vs Import for your scenario, covering performance, refresh cost, feature support, and fallback behavior." <commentary>Triggers for Microsoft Fabric integration, Direct Lake, OneLake, lakehouse connectivity</commentary> </example> <example> Context: User has a performance problem user: "My Power BI report is very slow, the visuals take 10+ seconds to load" assistant: "I'll guide you through a systematic performance investigation using Performance Analyzer, DAX Studio, and VertiPaq Analyzer to identify the bottleneck." <commentary>Triggers for performance optimization, DAX Studio, VertiPaq, slow reports</commentary> </example> <example> Context: User needs TMDL help user: "How do I write a TMDL file for a calculation group?" assistant: "I'll show you the TMDL syntax for defining a calculation group with time intelligence items." <commentary>Triggers for TMDL syntax, TMDL files, TMDL serialization, model definition language, tabular model definition</commentary> </example> <example> Context: User needs REST API help user: "How do I trigger a dataset refresh using the Power BI REST API with a service principal?" assistant: "I'll provide the API endpoint, authentication flow, and request body for programmatic dataset refresh." <commentary>Triggers for REST API endpoints, dataset refresh, service principal authentication, Power BI automation</commentary> </example>

This skill should be used when the user asks about "DAX formula", "DAX measure", "calculated column", "CALCULATE", "filter context", "row context", "context transition", "time intelligence", "SAMEPERIODLASTYEAR", "DATEADD", "YTD", "MTD", "TOTALYTD", "DAX patterns", "DAX optimization", "SUMX", "FILTER", "ALL", "REMOVEFILTERS", "variables in DAX", "VAR RETURN", "calculation groups", "field parameters", "DAX user-defined functions", "UDF", "visual calculations", "window functions", "WINDOW", "INDEX", "OFFSET", "ORDERBY", "PARTITIONBY", "MATCHBY", "INFO functions", "dynamic format strings", "TOTALWTD", "calendar-based time intelligence", "TABLEOF", "NAMEOF", or "DAX anti-patterns".

This skill should be used when the user asks about "Power BI deployment pipeline", "CI/CD for Power BI", "GitHub Actions Power BI", "Azure DevOps Power BI", "workspace management", "row-level security", "RLS", "object-level security", "OLS", "capacity management", "Premium", "PPU", "Fabric SKU", "tenant settings", "governance", "Power BI Report Server", "service principal setup", or "Power BI administration".

This skill should be used when the user asks about "Microsoft Fabric", "Direct Lake", "Direct Lake mode", "OneLake", "lakehouse Power BI", "Fabric warehouse", "Dataflow Gen2", "Fabric notebooks", "Fabric workspace", "Fabric capacity", "delta tables Power BI", "lakehouse connectivity", "Power BI in Fabric", "Fabric semantic model", "medallion architecture", "Semantic Link", "sempy", "V-Order", "Eventstream", "KQL Database", "Data Activator", or "composite model Direct Lake".

This skill should be used when the user asks about "Power BI performance", "slow report", "DAX Studio", "VertiPaq Analyzer", "Performance Analyzer", "optimize Power BI", "slow visuals", "aggregations", "composite model performance", "query reduction", "model size reduction", "VertiPaq compression", "Power BI best practices performance", "report optimization", "Direct Lake performance", "Direct Lake fallback", "visual calculations performance", "large dataset optimization", "10GB model", "Power BI Desktop performance settings", "Power BI Report Server performance", "bookmark optimization", "slow DAX", "DAX performance", "reduce model size", "query optimization", or "slow report".

This skill should be used when the user asks about "Power Query", "M language", "M code", "query folding", "data transformation", "custom connector", "Power Query parameters", "dynamic source", "query optimization", "Table.TransformColumns", "List.Generate", "error handling in M", "Power Query performance", "mashup engine", "advanced editor", "ETL", "merge queries", "append tables", "pivot columns", "unpivot", "remove duplicates", "split column", "combine files", "folder source", "Power Query Online", "Dataflow Gen2 M code", "refresh optimization", or "data transformation".

This skill should be used when the user asks about "Power BI data modeling", "star schema design", "relationships", "data sources", "DirectQuery vs Import", "Direct Lake mode", "composite models", "incremental refresh", "gateway setup", "VNet gateway", "streaming datasets", "Dataflow Gen2", "Power BI gotchas", "common pitfalls", "bidirectional filtering", "workspace identity", "OAuth2 data source", "service principal authentication", "semantic model", "Power BI architecture", "data model review", "Power BI Desktop settings", or general Power BI architecture and data connectivity questions.

This skill should be used when the user asks about "create Power BI report programmatically", "PBIR format", "PBIP developer mode", "Power BI project files", "TOM SDK", "Tabular Object Model", ".NET SDK for Power BI", "TMSL", "TMDL", "Tabular Editor scripting", "pbi-tools", "generate pbix", "code-first Power BI", "semantic model from code", "ALM Toolkit", "Power BI external tools", "TMDL basics (for detailed TMDL, load tmdl-mastery)", or "programmatic report generation".

This skill should be used when the user asks about "Power BI REST API", "Power BI API", "embed token", "service principal Power BI", "Power BI authentication", "dataset refresh API", "push dataset", "admin API", "Power BI Embedded", "JavaScript SDK", "embed report", "export to file API", "Power BI automation", "app registration", "Power BI API endpoint", "Power BI PowerShell", "MicrosoftPowerBIMgmt", "refresh dataset programmatically", "scanner API", "export report API", "clone report API", "workspace REST API", or "admin API".

This skill should be used when the user asks about "TMDL", "Tabular Model Definition Language", "TMDL syntax", "TMDL file structure", "TMDL folder", "TMDL serialization", "TmdlSerializer", "TMDL view in Power BI Desktop", "TMDL vs TMSL", "TMDL vs BIM", "model.tmdl", "database.tmdl", "relationships.tmdl", "TMDL expressions", "TMDL tables folder", "TMDL roles", "TMDL perspectives", "TMDL cultures", "TMDL translations", "TMDL annotations", "TMDL calculation groups", "TMDL CI/CD", "TMDL Git integration", "TMDL deployment", "createOrReplace TMDL", "TMDL scripts", "TMDL partitions", "TMDL hierarchies", "TMDL ref keyword", "convert BIM to TMDL", "TMDL format Power BI project", "PBIP TMDL", "semantic model source control", "TMDL indentation", "TMDL object declaration", "TMDL extended properties", "TMDL field parameters", "TMDL KPI", "TMDL VS Code extension", or "Tabular Editor TMDL".