wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use for Fabric Materialized Lake Views (MLVs) — CREATE MATERIALIZED LAKE VIEW Spark SQL (GA March 2026) + still-preview @fmlv.materializedlakeview PySpark decorator on a schema-enabled lakehouse (Runtime 1.3). Covers CREATE / SHOW / ALTER RENAME / DROP / REFRESH FULL syntax, CONSTRAINT ... CHECK ... ON MISMATCH…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use for Microsoft Fabric Real-Time Dashboards (KQLDashboard item) — authoring or editing RealTimeDashboard.json by hand or via Git: file anatomy (queries[] holds all KQL text; tiles reference it by queryRef.queryId; baseQueries are {id, variableName, queryId} wired through usedVariables), load-time validation (every…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use for Microsoft Fabric REST API patterns: listing and paginating workspaces/items with continuationToken/continuationUri, calling /v1/workspaces/{wsId}/items, handling long-running operations (202 Accepted, Location header, polling /v1/operations/{id}, Retry-After, /result), the runtime item ID vs .platform…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use for the Fabric security/permission model. Covers the layers (workspace roles Admin/Member/Contributor/Viewer, item-level Read/ReadData/ReadAll, OneLake security data access roles, SQL GRANT/DENY/REVOKE), Admin/Member/Contributor bypass of RLS/CLS/DDM, least-privilege pattern (Viewer + SQL GRANT), ReadData vs…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use when configuring AI instructions on a Power BI semantic model — the 10,000-character blob attached via Prep data for AI → Add AI instructions in Desktop or the service. Applies everywhere Copilot uses the model (reports, Q&A, Copilot pane). Covers what belongs in the blob (business context, terminology, date…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use for diagnosing Fabric Spark performance through the monitoring REST APIs — listing Livy sessions (/workspaces/{ws}/spark/livySessions with queuedDuration/runningDuration, HC session naming), pulling the Spark History Server mirror (notebooks, sparkJobDefinitions or lakehouses →…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use for PySpark / Spark in Microsoft Fabric notebooks. Covers the no-external-HTTP constraint (land data in Files/ first), abfss:// URI format for OneLake (GUIDs not names), notebookutils.runtime.context for identity lookups vs spark.conf. for session tuning, mssparkutils, lakehouse enableSchemas immutability and…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use for the Fabric Semantic Model Definition API — createItemWithDefinition / getDefinition / updateDefinition. Covers the two-audience rule (Fabric API for definitions, Power BI API for refresh/data sources/permissions), why updateDefinition MUST include ALL parts (modified and unmodified) or they're deleted, why you…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
TMDL (Tabular Model Definition Language) authoring rules for Fabric and Power BI semantic models. Use when editing .tmdl files, adding measures or columns to a semantic model, defining relationships or calculation groups, working in a PBIP definition/ folder, configuring Direct Lake partitions, or debugging TMDL…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use for Microsoft Fabric Variable Library — config-as-code for parameterizing notebooks and pipelines across environments. Covers definition parts (variables.json, settings.json, valueSets/ .json — no format field, omit it), variable types (String, Boolean, Number, Integer, DateTime, ItemReference), notebook…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use for monitoring Fabric Warehouse queries — OPTION (LABEL = '...') for tracking, the queryinsights schema (execrequestshistory, execsessionshistory, longrunningqueries, frequentlyrunqueries), 30-day retention, 15-minute appearance lag, the Invalid object name gotcha on newly-created warehouses, and diagnosing…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use for T-SQL against Fabric Warehouse (NOT Fabric SQL Database — see fabric-database). Covers unsupported types (nvarchar/datetime/money/xml/tinyint/hierarchyid), unsupported features (FOR XML, recursive CTEs, triggers, CREATE USER, cursors), MERGE (GA Jan 2026), ALTER COLUMN (preview), schema evolution (ADD nullable…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use when the user says 'learn!', 'capture this', 'update the skill', 'remember this for next time', or when a session surfaces a non-obvious pitfall, a doc-vs-reality gap, or a missing step in a skill/rule that was in use. Routes session learnings back into this repo's persistent guidance — skills//SKILL.md (+…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use for scripting an open Power BI Desktop model via its localhost msmdsrv.exe Analysis Services proxy — TOM (Microsoft.AnalysisServices.Tabular) for metadata, ADOMD.NET (AdomdConnection) for DAX. Covers PowerShell setup with retail.amd64 AMO/TOM + ADOMD NuGet DLLs, discovering the msmdsrv port (msmdsrv.port.txt /…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use when working with PBIP (Power BI Project) folders — the text-based developer format that replaces binary .pbix. Covers folder layout (.SemanticModel/, .Report/, definition/, StaticResources/), entry-point files (.pbip, .pbir, .pbism, .platform), byPath vs byConnection (thick vs thin report), .pbism version 4.2 /…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use when creating, editing, or wiring Power BI PBIR bookmarks in Report.Report/definition/bookmarks/ — bookmarks.json index and individual bookmark.json files. Covers bookmark structure (name hex ID matching items[], displayName, options, explorationState), options flags (targetVisualNames, suppressDisplay…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use when running the pbir CLI (install via uv tool install pbir-cli) to inspect or edit local Power BI PBIR reports. Covers path syntax (Report.Report/Page.Page/Visual.Visual with required type suffixes, glob patterns, property dot-notation), verb noun groups — report / page / visual / filter / bookmark / theme / dax…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use when adding conditional formatting to a Power BI visual — per-point bar/column colors, diverging gradients, line segment colors, marker transparency, data bars, conditional icons. Three approaches — measure-based (extension measure dataType Text returning theme tokens good/bad/neutral/minColor/midColor/maxColor)…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use when authoring filter bodies in a Power BI PBIR report at report.json, page.json, or visual.json filterConfig.filters. Covers scopes (Report, Page, Visual — visual filter is sibling of visual NOT nested), filter types (Categorical, Advanced, TopN, VisualTopN, RelativeDate, RelativeTime, Tuple), filter body shape…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use when authoring or editing page.json / pages.json inside a Power BI PBIR report's definition/pages/ folder. Covers top-level page properties (name hex GUID vs displayName, displayOption as STRING not integer, width/height, type Default vs Tooltip, visibility AlwaysVisible vs HiddenInViewMode…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use when scaffolding or building a new Power BI report end-to-end from a published semantic model using the pbir CLI. Covers the 10-step workflow — KPI / filter / granularity requirements, model field discovery via pbir model, pbir new report scaffold, renaming the default Page 1 instead of adding a new one, 3-30-300…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use when authoring or editing a Power BI report theme JSON under Report.Report/StaticResources/SharedResources/BaseThemes/ or RegisteredResources/. Covers top-level theme properties (name, dataColors palette, semantic colors background/foreground/tableAccent, sentiment good/bad/neutral/minimum/maximum/center…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Use when editing visual.json inside a Power BI PBIR report's visuals/ folder. Covers top-level structure (name, position, visual vs visualGroup mutually exclusive, filterConfig sibling NOT child of visual, root-level isHidden for bookmark toggles), expression literal suffixes — string 'text', double 14D, integer 14L…
wardawgmalvicious/agent-config
Skill Claude CodeCodex
Create and modify Power BI report files in PBIR/PBIP format using the powerbi-report-author and powerbi-desktop CLIs. Use when the user wants to: (1) implement an approved report spec or design brief, (2) add or edit pages, visuals, filters, slicers, bookmarks, themes, or formatting, (3) validate PBIR and verify…