Jason Lee
Community@9vantage
A 35-skill registry for authoring, consuming, diagnosing, and migrating Microsoft Fabric workloads including Power BI, Lakehouse, Warehouse, Eventhouse, and Spark.
Agent Skills by Jason Lee
Showing 35 vetted skills indexed across 1 GitHub repositories.
9vantagepowerbi-report-design
Generate Power BI report visual design guidance and design contracts before PBIR authoring.
9vantagecheck-updates
Checks GitHub releases for skills-for-fabric marketplace updates and displays changelogs.
9vantagesemantic-model-authoring
Create, edit, deploy, and optimize Power BI semantic models across Desktop, PBIP, and Fabric.
9vantagepowerbi-report-management
Manage Power BI report items and PBIR definitions in Microsoft Fabric via the REST API.
9vantagepowerbi-report-planning
Orchestrates requirements gathering, spec approval, and implementation for new Power BI reports.
9vantagepowerbi-report-authoring
Create and edit Power BI report files in PBIR/PBIP format using authoring CLIs.
9vantagesqldb-operations-cli
Diagnose SQL database in Fabric performance via sqlcmd against Query Store, DMVs, and Extended Events.
9vantagespark-operations-cli
Diagnose failed Spark jobs, Livy sessions, and performance bottlenecks in Microsoft Fabric via read-only CLI triage.
9vantagemlv-operations-cli
Manage Microsoft Fabric Materialized Lake View refresh schedules and job execution via REST APIs.
9vantagesqldw-operations-cli
Diagnose Fabric Data Warehouse performance using sqlcmd and queryinsights views.
9vantagefabriciq-ontology-authoring-cli
Create and update Fabric IQ Ontology items via the Fabric item-definition REST API.
9vantagedataflows-authoring-cli
Create, update, and refresh Fabric Dataflows Gen2 via CLI against Fabric REST APIs.
9vantageactivator-authoring-cli
Create and manage Fabric Activator alerts and rules via REST API and az CLI.
9vantageeventhouse-authoring-cli
Execute KQL management commands against Fabric Eventhouse and KQL Databases via Azure CLI.
9vantageeventstream-authoring-cli
Create and deploy Fabric Eventstream real-time streaming topologies via the Items REST API.
9vantagespark-authoring-cli
Develops Microsoft Fabric Spark notebooks and data engineering workflows via REST APIs and CLI.
9vantagesqldb-authoring-cli
Create and manage SQL databases in Microsoft Fabric using sqlcmd, SqlPackage, and az CLI.
9vantagee2e-medallion-architecture
Implements Bronze/Silver/Gold medallion lakehouse architectures in Microsoft Fabric using PySpark and Delta Lake.
9vantagesqldw-authoring-cli
Execute T-SQL DDL, DML, and data ingestion against Microsoft Fabric warehouses from CLI environments.
9vantagedataflows-save-as-authoring-cli
Assess and execute Power BI dataflow Gen1 to Gen2.1 save-as upgrades via CLI.
9vantageactivator-consumption-cli
Inspect Fabric Activator alerts, rules, and definitions via read-only REST API calls.
9vantagespark-consumption-cli
Analyze lakehouse data interactively using Fabric Lakehouse Livy API sessions and PySpark.
9vantageeventhouse-consumption-cli
Run read-only KQL queries against Microsoft Fabric Eventhouse via the Kusto REST API.
9vantagepipeline-migration
Migrate Synapse Data Factory pipelines to Microsoft Fabric Data Factory via REST APIs.
Frequently Asked Questions About Jason Lee
FAQPage SchemaWhat tasks can I perform with 9vantage's skills-for-fabric registry?▼
You can author and query Fabric items end-to-end: build Power BI reports and semantic models with DAX, create Dataflows Gen2, Eventstreams, Eventhouse KQL tables, and Activator alerts, run T-SQL/KQL/PySpark queries, diagnose slow queries and failed Spark jobs, and migrate Synapse, Databricks, or HDInsight workloads into Fabric.
Who are these skills designed for?▼
Data engineers, BI developers, and analytics engineers working in Microsoft Fabric. Typical users include Power BI report authors managing PBIR/PBIP files, Spark engineers triaging Lakehouse jobs, warehouse developers running T-SQL via sqlcmd, and platform teams porting Synapse, Databricks, or HDInsight estates to Fabric.
How do the skills execute against Microsoft Fabric at runtime?▼
Skills run from agentic CLI environments using az rest against Fabric REST APIs, sqlcmd against SQL endpoints, the Kusto REST API for KQL, Livy sessions for PySpark, and dedicated CLIs like powerbi-report-author. The check-updates skill compares local versions against GitHub releases at session start.
Are these skills free and open source?▼
The registry is distributed via the skills-for-fabric GitHub repository with a public marketplace update mechanism and changelog. Usage requires your own Microsoft Fabric capacity and workspace permissions; the skills themselves only orchestrate existing Fabric REST APIs and endpoints your identity can access.
What prerequisites and dependencies are required?▼
You need an active Microsoft Fabric workspace with appropriate item permissions, Azure CLI (az) for REST calls, sqlcmd for SQL database and warehouse endpoints, and Power BI Desktop for PBIR validation. Migration skills require access to source Synapse, Databricks, or HDInsight artifacts being ported.