Powerbi Connect Pbid
TOM and ADOMD.NET guidance via PowerShell for connecting to Power BI Desktop's local Analysis Services instance. Covers model enumeration, DAX queries, metadata modification, annotations, calendar definitions, field parameters, query tracing, and DAX library package management (daxlib.org). Automatically invoke when the user mentions "Power BI Desktop", "Analysis Services port", "TOM", "ADOMD", "…
Powerbi Measure Glossary
Standard measure naming and documentation. Use when the user mentions: measure lineage, measure description, formula documentation, DAX glossary, business glossary, measure visibility, what does this measure do, measure dependency, measure catalogue, document measures, annotate measures, formula visibility, where is this measure used, measure impact, self-documenting model.
Powerbi Dax
Execute and validate DAX queries and expressions against a connected Power BI Desktop model via powerbi-agent. Invoke when the user mentions DAX, asks to run a query, test a formula, use EVALUATE / CALCULATE / SUMMARIZECOLUMNS, or validate an expression before saving as a measure. Use when the user mentions: Activate when the user wants to run a DAX query, test a DAX expression, validate syntax,…
Databricks Connect
Quick start guide for connecting databricks-agent to a Databricks workspace using PAT tokens or OAuth. Use when the user mentions: connect, databricks connect, connection issues, authentication, workspace, token, oauth, profile, databricks-agent connect, how to connect, no workspace.
Powerbi Report Conversion
Power BI report format conversion, merging, splitting, and semantic model rebinding via pbir.tools - PBIR/PBIP/PBIX conversion, multi-report merging, page splitting, thick/thin PBIP operations, and model rebind. Use when the user mentions: convert report, PBIR, PBIP, PBIX, format conversion, merge reports, split pages, split report, rebind dataset, rebind semantic model, thick PBIP, thin report,…
Powerbi Data Catalog Lineage
Data catalog and lineage management. Use when the user mentions: data catalog, lineage, data governance, Microsoft Purview, data dictionary, metadata, data discovery, impact analysis, endorsement, certified, promoted, scan, data map, business glossary, column-level lineage, table lineage, sensitivity label, data quality score.
Powerbi Deneb Visuals
Deneb visual creation, Vega/Vega-Lite spec authoring, and Deneb best practices for PBIR reports. Automatically invoke whenever the user mentions "Deneb" in any context, or asks about Vega/Vega-Lite specs in Power BI, Deneb cross-filtering, Deneb interactivity, pbiColor theme integration, Deneb field name escaping, or Deneb rendering issues.
Databricks Security Governance
Unity Catalog row filters, column masks, table ACLs, data masking, service principals, workspace access, PII governance, and audit logging. Use when the user mentions: row filter, column mask, data masking, RLS, row-level security, column-level security, access control, permissions, ACL, service principal, PII, sensitive data, audit log, governance, Unity Catalog security, GRANT, REVOKE.
Databricks Metric Glossary
Metric definitions, dbt metrics, Unity Catalog documentation, Databricks AI/BI Semantic Layer, business glossary, and metric dependency tracking. Use when the user mentions: metric documentation, measure documentation, business glossary, dbt metrics, semantic layer, metric definition, KPI definition, dependencies, lineage, data dictionary, metric catalog, undocumented tables, metric audit.
Powerbi Lineage Analysis
Trace relationships between semantic models and downstream reports across Fabric workspaces. Automatically invoke when the user asks to "find downstream reports", "show report lineage", "impact analysis", "what depends on this dataset", "cross-workspace lineage", "which reports are connected", "get model dependencies", or mentions model-to-report dependency tracing.
Powerbi Standardize Naming Conventions
Interactive naming convention standardization for TMDL-based Power BI semantic models. Automatically invoke when the user asks to "standardize naming conventions", "fix naming conventions", "clean up model names", "apply naming standards", "audit naming", "make names human readable", "rename fields", "fix abbreviations in model", or mentions renaming measures, columns, or tables for consistency a…
Powerbi Time Series Data
Time series analysis patterns. Use when the user mentions: time series, gaps in data, missing dates, sparse data, irregular intervals, binning, time buckets, rounding timestamps, 5-minute intervals, hourly buckets, normalise time, fill gaps, spine, date spine, continuous axis, aggregation over time, interval aggregation, IoT, sensor data, event data, tick data.
Powerbi Report Design
Power BI report design principles, layout guidance, and formatting best practices. Automatically invoke when the user asks about "report layout", "design best practices", "visual hierarchy", "3-30-300 rule", "KPI card design", "page layout", "accessibility in reports", "visual spacing", "report canvas", "card design patterns", "table formatting", "matrix formatting", or mentions report design pri…
Powerbi Star Schema Modeling
Star schema design, dimensions, facts. Use when the user mentions: star schema, snowflake schema, dimensional modeling, Kimball, fact table, dimension table, surrogate key, grain, SCD, conformed dimensions, data mart, data warehouse, DW design, ERD, relationship design.
Powerbi Pbir Format Enhanced
Format reference for Power BI Enhanced Report (PBIR) JSON schemas and patterns. Automatically invoke when the user asks about PBIR JSON structure, visual.json properties, PBIR expressions, objects vs visualContainerObjects, theme inheritance, conditional formatting patterns, extension measures, bookmarks, field references, filter formatting, query roles, PBIR page structure, report wallpaper, or…
Powerbi Dax Mastery
DAX measures, time intelligence, evaluation context. Use when the user mentions: DAX, measure, calculated column, calculate, filter context, row context, time intelligence, SUMX, CALCULATE, ALL, ALLEXCEPT, RANKX, TREATAS, YTD, YoY, MTD, rolling average, running total, DAX error, formula, expression, context transition.
Powerbi Fabric
Manage Microsoft Fabric / Power BI Service workspaces and datasets via powerbi-agent — authenticate, list workspaces, list datasets, trigger refreshes. Invoke when the user mentions Fabric, Power BI Service, workspace, dataset refresh, or publishing to the cloud. Use when the user mentions: Activate when the user mentions Microsoft Fabric, Power BI Service, workspaces, cloud datasets, or dataset…
Powerbi Report Authoring
General report authoring patterns. Use when the user mentions: report, page, visual, chart, bar chart, line chart, matrix, table, slicer, filter, bookmark, tooltip, drill-through, navigation, layout, canvas, report design, visual formatting, conditional formatting, KPI, card, decomposition tree.
Powerbi Source Integration
Source system integration patterns. Use when the user mentions: data source, connect source, ingest data, database connection, API connection, CSV upload, web scrape, source connector, raw data model, normalize, Bronze ingestion, source mapping, data model development, source to Bronze, multi-source, PostgreSQL, postgres, JDBC, RDS, Aurora, Azure Database for PostgreSQL, Cloud SQL, read replica,…
Databricks Testing Validation
Data testing patterns for Databricks - DLT expectations, Delta constraints, Great Expectations, dbt tests, Spark unit tests, reconciliation, UAT. Use when the user mentions: testing, unit test, data quality, validate, assertion, UAT, reconciliation, Great Expectations, dbt test, DLT expectations, Delta constraints, pytest, data validation, quality checks, row count, null check.
Powerbi Model
Inspect and modify the connected Power BI Desktop semantic model using powerbi-agent — list tables, measures, relationships, and add new measures. Invoke when the user asks about the data model, wants a measure list, needs to add a measure, or is exploring table structure and relationships. Use when the user mentions: Activate when the user wants to inspect tables / measures / relationships, asks…
Databricks Project Management
Databricks project delivery lifecycle - discovery, foundation, build, UAT, go-live, data product mindset, agile sprints, RAID logs. Use when the user mentions: project plan, sprint, milestone, scope, backlog, data product, agile, go-live, RAID log, delivery, timeline, stakeholder, requirements, UAT, hypercare.
Powerbi Report Structure
Programmatic Power BI report structure automation via pbir.tools - add/delete/reorder pages, create/position/bind visuals, manage filters, bookmarks, and visual field bindings without opening Power BI Desktop. Use when the user mentions: add page, add visual, add filter, add bookmark, delete page, delete visual, remove visual, reorder pages, hide page, bind field, field binding, visual field, fil…
Powerbi Modifying Theme Json
Design, enforce, audit, and validate Power BI report themes. This skill MUST be invoked when a report uses the default or built-in theme, has a minimal custom theme (few or no visualStyles), or has accumulated many visual-level formatting overrides (objects/visualContainerObjects in visual.json); these are signs the theme needs attention. Also automatically invoke when the user asks to "create a…
Databricks Dlt Pipelines
Delta Live Tables (DLT) pipeline patterns, ingestion strategies, CDC, Auto Loader, incremental loads, watermark, and Databricks Workflows. Use when the user mentions: ETL, ELT, DLT, delta live tables, pipeline, ingestion, incremental load, CDC, change data capture, watermark, Auto Loader, streaming, workflow, job, trigger, continuous, scheduled, bronze silver gold.
Databricks Dashboard Authoring
Databricks AI/BI Lakeview dashboards, DBSQL visualizations, design principles, interactivity, layout, and accessibility. Use when the user mentions: dashboard, visualization, chart, report, lakeview, DBSQL, sql dashboard, filters, parameters, drilldown, KPI widget, counter, heatmap, AI/BI, design, layout.
Databricks Spark Sql Mastery
Spark SQL and DataFrame API mastery - window functions, aggregations, CTEs, query optimization, and advanced analytical patterns. Use when the user mentions: spark sql, dataframe api, window function, aggregation, GROUP BY, CTE, subquery, analytical query, OVER PARTITION, rank, lead lag, running total, pivot, unpivot, query optimization, explain plan.
Databricks Time Series Data
Time series patterns in Databricks - gap detection, date spines, binning, LOCF, streaming windows, IoT and sensor data patterns. Use when the user mentions: time series, gaps, sparse data, binning, time buckets, IoT, sensor data, tick data, date spine, gap filling, LOCF, last observation, normalize time, streaming window, tumbling window, sliding window, session window.
Powerbi Doctor
Diagnose powerbi-agent environment issues — Python/pythonnet install, Power BI Desktop detection, SSAS port access, Fabric auth state. Invoke when the user reports setup issues, connection failures, import errors, or asks "why isn't this working". Use when the user mentions: Activate when the user reports connection problems, setup issues, import errors (pythonnet, clr, pyadomd), "command not fou…
Powerbi Pbip Format
Expert guidance for the Power BI Project (PBIP) file format; project structure, cross-cutting operations (renames, forking), and PBIX extraction/conversion. Automatically invoke when the user mentions PBIP, PBIX, .pbip/.pbism/.platform files, or asks about "PBIP project structure", "PBIP vs PBIX", "thin report vs thick report", "rename a table", "cascade rename", "fork a PBIP project", "convert p…
Powerbi Svg Visuals
SVG generation via DAX measures and extension measures with ImageUrl data category for inline visualizations in PBIR reports. Automatically invoke when the user mentions "SVG visual", "DAX sparkline", "SVG measure", "inline graphics with DAX", "ImageUrl data category", "extension measure", or asks to create any DAX-generated chart (progress bars, bullet charts, KPI indicators, data bars, gauges,…
Powerbi Data Transformation
ETL/ELT transformation patterns. Use when the user mentions: union, append, stack tables, combine datasets, convert data types, cast, type mismatch, key generation, surrogate key, hash key, join key, light join, merge, schema alignment, homogenise, data harmonisation, Power Query union, Spark union, M append, combine queries.
Databricks Data Transformation
PySpark and Spark SQL transformation patterns - union, append, type casting, surrogate keys, schema drift, Delta merge. Use when the user mentions: union, append, stack tables, convert data types, surrogate key, schema alignment, type casting, data transformation, merge, upsert, deduplication, schema drift, normalize, flatten.
Databricks Medallion Architecture
Bronze/Silver/Gold medallion architecture on Databricks Delta Lake - layer design, naming conventions, Delta optimizations, V-Order, Liquid Clustering. Use when the user mentions: medallion, bronze, silver, gold, lakehouse, delta lake, layer design, data architecture, delta table, liquid clustering, v-order, z-order, optimize, vacuum, time travel.
Powerbi Dax Performance
DAX performance optimization for semantic models. Automatically invoke when the user asks to "optimize DAX", "fix slow DAX", "DAX performance", "tune a measure", "debug a measure", "DAX anti-patterns", or mentions slow queries, server timings, or DAX authoring.
Powerbi Create Pbi Report
Step-by-step workflow for creating complete Power BI reports from scratch using pbir CLI. Covers model discovery, report creation, page layout, theme setup, visual placement, field binding, filtering, formatting, validation, and publishing. Automatically invoke when the user asks to "create a new report", "build a report from scratch", "make a dashboard", "set up a report with KPIs", "create an e…
Powerbi Te2 Cli
CLI syntax reference for Tabular Editor 2 (TabularEditor.exe); deployment, scripting, BPA analysis, and CI/CD integration. Automatically invoke when the user mentions "TabularEditor.exe", TE2 CLI flags (-D, -S, -A, -B, -TMDL, -O, -C), or asks to "deploy a model via CLI", "set up CI/CD for Power BI", "automate model deployment", "run BPA from command line", "save model as TMDL".
Powerbi Fabric Cli
Expert guidance for using the Fabric CLI (`fab`) to fully interact with Fabric workspaces, items, and configuration. Automatically invoke this skill whenever the user mentions "Fabric" or "Power BI Service" or a "Fabric/Power BI workspace".
Powerbi Security Rls
Row-level security design and implementation. Use when the user mentions: RLS, row-level security, OLS, object-level security, column security, roles, security filter, USERPRINCIPALNAME, USERNAME, dynamic security, static security, permissions, access control, data governance, sensitivity labels, workspace roles.
Powerbi Medallion Architecture
Bronze/Silver/Gold lakehouse design. Use when the user mentions: medallion, bronze, silver, gold, lakehouse, data lake, data architecture, layer design, raw layer, curated layer, semantic layer, OneLake.
Powerbi Review Report
Actionable feedback on the quality, usage, and effectiveness of Power BI reports. Automatically invoke when the user asks to "review a report", "audit a report", "report usage analysis", "report health check", "find unused reports", "check if a report is being used", "assess report performance", "evaluate report quality".
Powerbi Fabric Pipelines
Fabric Data Factory pipelines and orchestration. Use when the user mentions: data pipeline, ingestion, ETL, ELT, Fabric pipeline, Data Factory, copy activity, notebook, Spark, dataflow gen2, lakehouse, OneLake, data load, incremental load, watermark, CDC, change data capture, full load, delta load, pipeline orchestration.
Powerbi Pbir Cli
Advanced Power BI report manipulation and execution using pbir CLI and object model; executable scripts for complex workflows, domain-specific references, and reusable templates. Automatically invoke when the user works with .pbir/.pbip report files, or asks to "add a visual", "format a chart", "bind fields", "set a theme", "add conditional formatting", "create a page", "add a thin-report measure…
Powerbi Python Visuals
Python visual creation and matplotlib/seaborn patterns for PBIR reports. Automatically invoke when the user mentions "Python visual", "matplotlib in Power BI", "seaborn in Power BI", "pythonVisual", or asks to "create a Python visual", "add a matplotlib chart", "write a Python visual script".
Powerbi Cyber Security
Power BI and Microsoft Fabric cybersecurity - tenant hardening, conditional access, OAuth flows, export controls, data exfiltration prevention, audit log threat detection, and compliance controls. Use when the user mentions: cyber security, cybersecurity, tenant hardening, conditional access, MFA, OAuth, export control, data exfiltration, threat detection, zero trust, SOC2, HIPAA, PCI-DSS, vulner…
Powerbi Review Semantic Model
Review, audit, and validate Power BI semantic models against quality, performance, and best practice standards. Automatically invoke when the user asks to "review a semantic model", "audit a semantic model", "check model quality", "optimize my model", "validate model design", "check AI readiness", "prepare model for Copilot", or mentions model validation or quality assessment.
Powerbi R Visuals
R visual creation and ggplot2 patterns for PBIR reports. Automatically invoke when the user mentions "R visual", "ggplot2", "ggplot in Power BI", or asks to "create an R visual", "add an R chart", "write an R visual script", "inject an R script into Power BI".
Databricks Cyber Security
Databricks cybersecurity posture - network isolation, secrets hygiene, threat detection, zero-trust architecture, credential scanning, SOC2/HIPAA controls, and incident response. Use when the user mentions: cyber security, cybersecurity, network isolation, private endpoint, secrets, credential leak, threat detection, zero trust, SOC2, HIPAA, PCI-DSS, vulnerability, attack surface, hardening, inci…
Powerbi Data Governance Traceability
End-to-end data governance traceability for Power BI and Microsoft Fabric - GDPR/CCPA compliance, Purview lineage, sensitivity labels, retention, consent, and audit-ready evidence packages. Use when the user mentions: governance traceability, data lineage chain, GDPR, CCPA, HIPAA, data retention, right to erasure, data subject request, DSR, consent tracking, regulatory compliance, data classifica…
Powerbi Report Theming
Power BI report theming via pbir.tools - color palettes, typography, text classes, theme templates, visual formatting, icons, background images, and conditional formatting rules. Use when the user mentions: theme, theming, color palette, brand colors, fonts, typography, text class, formatting, conditional formatting, theme template, theme apply, icon, background image, visual style, report style,…
Powerbi Te Docs
Look up Tabular Editor (TE2 / TE3) documentation — C# scripting cookbook, BPA rule reference, CLI flags, dynamic format strings, calculation groups, TOM/TMSL APIs. Automatically invoke when the user asks about a Tabular Editor feature, scripting recipe, BPA rule, CLI flag, calculation group syntax, dynamic format string, or quotes a TE error message; or mentions Tabular Editor, TE2, TE3, ScriptHe…
Powerbi Project Management
Project management for BI projects. Use when the user mentions: project plan, sprint, milestone, delivery, roadmap, stakeholder, requirements, scope, backlog, user story, epic, data product, product management, agile, kanban, release plan, go-live, risk, RAID log, data platform delivery, data project, BI delivery, analytics delivery, change management, business case.
Powerbi Audit Tenant Settings
Automatically invoke this skill whenever the user asks about Fabric tenant settings or Power BI tenant settings or auditing tenant settings. You can use this skill if the user mentions "Fabric administration".
Powerbi C Sharp Scripting
Writing and executing C# scripts and macros against Power BI semantic models using Tabular Editor 2/3. Automatically invoke when the user mentions "C# script", "Tabular Editor script", "TOM scripting", "MacroActions.json", "XMLA", or asks to "automate model changes", "bulk update measures", "create calculation groups", "write a macro", "format DAX expressions", "manage model metadata".
Databricks Data Catalog Lineage
Unity Catalog lineage, data governance, column-level lineage, tagging, endorsement, and impact analysis in Databricks. Use when the user mentions: data catalog, lineage, data governance, unity catalog, metadata, endorsement, sensitive data, column lineage, data discovery, impact analysis, data dictionary, table tags, purview.
Powerbi Power Query
Author, validate, and test Power Query M expressions in semantic model partitions. Automatically invoke when the user mentions "Power Query", "M code", "M expression", "partition expression", "query folding", or asks to "write Power Query", "fix Power Query", "test a partition", "preview partition data", "debug Power Query step", "optimize Power Query".
Powerbi Refresh Semantic Model
Automatically invoke this skill whenever the user asks to refresh a semantic model or a dataset. Can also be used to manage, optimize, troubleshoot, or configure a refresh or a refresh schedule.
Databricks Data Governance Traceability
End-to-end data governance traceability in Databricks - regulatory compliance (GDPR, CCPA, HIPAA), data lineage chains, retention policies, classification, consent tracking, and audit-ready evidence. Use when the user mentions: governance traceability, data lineage chain, GDPR, CCPA, HIPAA, data retention, right to erasure, data subject request, DSR, consent tracking, regulatory compliance, data…
Databricks Source Integration
Data source integration patterns - Auto Loader, JDBC/ODBC, cloud storage, Kafka, REST APIs, CSV files, and the databricks-agent UI for pipeline configuration. Use when the user mentions: data ingestion, connections, pipeline setup, sources, JDBC, ODBC, databases, APIs, REST API, Kafka, Auto Loader, cloud storage, S3, ADLS, GCS, CSV, JSON, Parquet, streaming, batch ingest, PostgreSQL, postgres, JD…
Databricks Delta Modeling
Delta table design, star schema on Delta Lake, fact/dimension tables, SCD strategies, surrogate keys, additivity rules, and anti-patterns. Use when the user mentions: star schema, dimensional modeling, fact table, dimension, SCD, slowly changing dimension, surrogate key, grain, additivity, snowflake schema, data vault, delta table design, schema design, model, normalize, denormalize.
Powerbi Testing Validation
Testing and validation frameworks. Use when the user mentions: testing, test, unit test, DAX test, data quality, validate, assertion, reconciliation, UAT, user acceptance testing, regression test, data test, test pipeline, PQTest, Great Expectations, data contract, row count, sum check, null check, business logic test, source vs target, reconcile.
Powerbi Custom Visuals
Build, package, and embed Power BI custom visuals (.pbiviz) into PBIR reports via the powerbi-visuals SDK. Automatically invoke when the user asks to "create a custom visual", "vibe-code a visual", "build a pbiviz", "scaffold a custom visual project", "import a custom visual into the report", "iterate on visual.ts", or mentions powerbi-visuals-tools, pbiviz, capabilities.json, IVisual, or D3-base…
Powerbi Bpa Rules
Interactive BPA rule generation for Power BI semantic models; guided discovery, model investigation, and expert rule authoring. Automatically invoke when the user mentions "BPA rule", "Best Practice Analyzer", or asks to "create a BPA rule", "audit BPA rules", "recommend BPA rules", "set up BPA for my team", "check model for best practices", "validate BPA rules", "improve a BPA expression".
Powerbi Report
Inspect and modify Power BI report structure (PBIR / .pbir) using powerbi-agent — show report info, list pages, add pages. Invoke when the user asks about report pages, visuals, bookmarks, or wants to scaffold new report content. Use when the user mentions: Activate when the user asks about report pages, report structure, visuals, bookmarks, or wants to add a new page. Works against unpacked PBIR…
Powerbi Connect
Connect powerbi-agent to a running Power BI Desktop instance. Invoke when the user wants to connect to Power BI Desktop, mentions "connect", "pbi connect", "local instance", sees "no connection" errors, or cannot run DAX/model commands against their model. Use when the user mentions: Activate when the user wants to connect to Power BI Desktop, mentions "connect", "pbi connect", "local instance",…
Powerbi Performance Scale
Performance optimization and scaling. Use when the user mentions: slow report, performance, DirectQuery, DirectLake, Import mode, aggregations, composite model, large dataset, timeout, query performance, DAX Studio, Performance Analyzer, V-Order, OPTIMIZE, memory, Premium, Fabric capacity, large model.
Databricks Performance Scale
Databricks cluster optimization, Delta query tuning, caching, partitioning, autoscaling, photon, and capacity planning. Use when the user mentions: slow query, performance, optimization, cluster sizing, autoscaling, photon, caching, partitioning, skew, shuffle, spill, query tuning, capacity planning, cost optimization, warehouse sizing, adaptive query execution.