Powerbi Report CLI
MicrosoftOfficialPublished by Microsoft
- Skill
- Tool integration
- Data and AI
- MIT
- Low risk
AutoGineer summary
Written by AutoGineer from the skill’s own files, not by the author
The powerbi-report-cli skill provides a structured, mode-based framework for managing the entire Power BI report lifecycle. It acts as a dispatcher across four distinct phases: planning (requirements and scope), design (visual and layout strategy), authoring (local PBIR/PBIP file manipulation and validation), and management (Fabric item transport and rebinding). The skill enforces strict boundaries between these modes to ensure quality, requiring explicit approval for new reports and utilizing a dedicated CLI for metadata-driven validation and authoring tasks.
What it does
- Guides users through report requirements, scope, and page planning.
- Provides design contracts for visual archetypes, layouts, and branding.
- Enables local editing, validation, and previewing of PBIR and PBIP files.
- Handles report item transport to and from Microsoft Fabric.
- Supports re-theming, conditional formatting, and visual configuration.
- Enforces a mandatory approval gate for greenfield report development.
When to use it
- When planning a new Power BI report from a semantic model.
- When you need to define a professional design brief or layout strategy.
- When editing local PBIR/PBIP files, including visuals, filters, and themes.
- When validating report structure and formatting before deployment.
- When publishing or managing report items within a Fabric workspace.
Advantages
- Ensures consistent report quality through a structured, multi-mode workflow.
- Prevents premature publishing by enforcing a mandatory approval barrier.
- Uses a dedicated CLI to eliminate guesswork in PBIR schema and property editing.
- Maintains clear separation between design intent and technical implementation.
- Provides robust validation tools to catch errors before Fabric deployment.
Usage examples
- “Create a new executive report from this semantic model.”
- The agent enters planning mode, inspects the model, generates a report spec, and requests user approval before proceeding.
- “Design an operational page and choose the right charts.”
- The agent enters design mode, produces a design brief with page archetypes and chart recommendations.
- “Add a KPI page to this PBIP, validate it, and take screenshots.”
- The agent enters authoring mode, modifies the local PBIP files, runs validation, and captures screenshots for review.
- “Publish this local PBIP to my Fabric workspace and rebind it.”
- The agent enters management mode, performs the upload to Fabric, and completes the rebind operation.
Install
Download the skill as a ZIP:
https://mp-staging.autogineer.com/agent-skills/microsoft/powerbi-report-cli/downloadUnzip it into the cross-client skills folder of your project:
mkdir -p .agents/skills && unzip powerbi-report-cli.zip -d .agents/skills
Documentation by Microsoft
Telemetry — MANDATORY. Every
api.fabric.microsoft.comcall must carryx-ms-fabric-skill: powerbi-report-cli(az rest:--headers "x-ms-fabric-skill=powerbi-report-cli"), including every LRO poll,fabric_lroand retry. Snippets omit it — add it anyway.
CRITICAL NOTES
To find workspace details, including its ID, from a workspace name: list all workspaces, then use JMESPath filtering.
To find item details, including its ID, from a workspace ID, item type, and item name: list all items of that type in that workspace, then use JMESPath filtering.
Use
powerbi-report-clifor the report artifact: requirements, design, PBIR/PBIP page and visual edits, preview, and publishing. Semantic model, measure, and DAX work belongs to a semantic-model skill. Natural-language questions about report data belong tofabriciq.
Power BI Reports - CLI Skill
This skill owns the Power BI report lifecycle end to end: requirements and scope, visual design, local PBIR/PBIP authoring and preview, and report-item transport to and from Microsoft Fabric.
It is a mode dispatcher and intentionally contains no detailed procedures. Select the mode that matches the request, then read the matching mode reference end to end before acting. The mode file holds the required workflow, commands, payloads, templates, and failure rules.
Mode Selection
| Mode | Use when the request... | Existing route examples | Read first |
|---|---|---|---|
planning | creates a new report/dashboard and needs requirements, model/dependency inspection, scope, a page plan, and approval before implementation | create a report, build a dashboard, create from a semantic model, plan then implement, walk me through creating a report | references/planning.md, then references/planning-part-02.md |
design | decides what a report should look like: tone, signature, page archetype, chart type, layout, color, typography, theme direction, accessibility, brand application, redesign, or critique | design a Power BI report, make the dashboard professional, choose a chart, apply a brand, redesign the report, create a design brief | references/design.md |
authoring | reads or edits local PBIR/PBIP files, validates them, previews the report, or captures screenshots | edit PBIR, create/add a report page or visual, format a visual, add filters/slicers/bookmarks/themes, validate PBIR, preview/reload/screenshot in Desktop or service | references/authoring.md |
management | moves a report definition to or from Fabric or manages the workspace report item | publish/upload/download PBIR or PBIP, list reports, get/update/delete a report, rebind a report | references/management.md |
Mode Boundary Rules
Classify by intent, not by which file or tool is already open.
designdecides what the report should look like;authoringwrites the PBIR that realizes it. Choosing a chart type isdesign; encoding it intovisual.jsonisauthoring.Restyling or reformatting an existing local report is
authoring, even when the request uses design language. Usedesignwhen the user wants advice or a design contract rather than a file change.authoringchanges local files and performs preview/validation. It does not publish to Fabric.managementtransports definitions and manages Fabric report items. It does not invent or directly author PBIR content.planningowns the guided requirements-to-approval flow for a new report. A focused edit to an existing report goes directly toauthoring.
A greenfield request can span modes in this order:
planning -> design -> authoring -> managementHandle one mode at a time. Announce each switch and read the new mode reference
before starting that part. The planning approval gate is a turn boundary:
never build or publish until the user explicitly approves the locked spec in a
later reply.
GREENFIELD APPROVAL BARRIER — MANDATORY. When a new-report request asks to plan, build, and/or publish but the user has not approved a locked spec in a prior reply, set the current phase to
approval_pendingand keepplanningas the only active mode. In this phase, do not loadauthoringormanagement, edit/scaffold PBIR or semantic-model files, generate synthetic data, call Fabric write APIs, or publish. Persist_brief/report-spec.md, ask for explicit approval, and end the turn. The build/publish wording in the original request is desired future scope, not approval to cross this barrier.
Required Deliverable by Mode
| Mode | Completion requirement |
|---|---|
planning | Persist _brief/report-spec.md or the user-named equivalent, ask for explicit approval, and stop before implementation. |
design | Produce the complete Design Brief: contract, including design_identity and a page archetype/layout contract for every page. Do not edit PBIR or call Fabric APIs. |
authoring | Persist the requested PBIR/PBIP changes, validate each logical batch, then complete the selected preview and screenshot-review workflow required by the authoring reference. Do not publish. |
management | Complete the requested Fabric report operation, including LRO polling and documented readback verification. |
Rules
MUST
Select the narrowest mode that fully covers the current request.
Read
references/<mode>.mdend to end before the first command or file edit in that mode. When an already-loaded mode explicitly routes one narrow cross-mode operation to a named topic reference, treat that topic reference as the complete handoff; do not load the target mode's umbrella file unless the work expands beyond that operation.In
planningmode, also readreferences/planning-part-02.mdbefore producing_brief/report-spec.md; it contains the required canonical design contract and approval checks.Across a multi-turn task, retain a compact working state containing resolved workspace/item/model IDs, local and downloaded paths, and references already read. Reuse it in later turns unless the user explicitly requests a fresh query or the preceding operation invalidated a value.
Preserve every argument and safety boundary documented by the selected mode.
Announce and perform an explicit mode switch when the request crosses a boundary.
Use the
powerbi-report-authorCLI metadata and validation surfaces instead of guessing PBIR schemas, roles, formatting properties, selectors, or enum values.Keep local edits local unless the user explicitly requests publishing.
Resolve Fabric workspace and item IDs by listing and filtering rather than guessing identifiers.
Produce the artifact the user requested; reading or summarizing a reference is not task completion.
PREFER
Infer facts already present in the prompt, semantic model, existing PBIP, or prior approved spec instead of asking again.
Load only the selected mode and its directly relevant topic references.
Reuse reference guidance already loaded in the current task. Open a new reference only when the requested operation or an observed mismatch requires it.
Preserve the user's existing project structure, schemas, host, operation, binding, and delivery target unless the selected mode explicitly requires a change.
AVOID
Acting from this dispatcher without reading the selected mode reference.
Reloading this dispatcher, a mode file, or a topic reference already read in the current task solely because the conversation advanced to a later turn.
Loading a retired sibling skill name; planning, design, authoring, and management are modes of this skill.
Editing PBIR or calling Fabric APIs in
planningordesign.Publishing from
authoring, or authoring PBIR content frommanagement.Bypassing the planning approval gate because the original request also asked to build or publish.
<!-- BEGIN GENERATED REFERENCE INDEX -->
Complete Reference Index
Open every relevant reference directly from this index. Files named part-XX continue the named topic.
Authoring
Design
Mode Guides
<!-- END GENERATED REFERENCE INDEX -->
Examples
| User request | Mode |
|---|---|
| "Create a new executive report from this semantic model." | planning |
| "Design an operational page and choose the right charts." | design |
| "Add a KPI page to this PBIP, validate it, and take screenshots." | authoring |
| "Publish this local PBIP to my Fabric workspace and rebind it." | management |
Route Compatibility
The merged skill preserves the four previous route surfaces. Treat the following phrases as explicit aliases for the corresponding mode:
| Mode | Preserved route phrases |
|---|---|
planning | create a report; build a report; create a dashboard; create a new report from scratch; create a report from a semantic model or dataset link; build a report for this model; make me a dashboard; plan then implement; walk me through creating a report |
design | design Power BI report; make dashboard look professional; choose chart type; apply brand to report; redesign report; create design brief; Power BI report design archetype |
authoring | edit PBIR; create Power BI report page; add visual to PBIP; format report visual; validate Power BI report; preview Power BI report; Power BI Desktop preview status; preview report in service; preview report in browser; screenshot report page; screenshot all report pages; list preview hosts; implement dashboard in PBIP; add dashboard visuals to report; implement an approved PBIP report spec; edit PBIR pages/visuals; edit a Power BI report |
management | upload PBIR report definition; upload Power BI report; download PBIR definition; publish PBIR definition; publish Power BI report to Fabric; manage Power BI reports; list workspace reports |
Files
- ATTRIBUTION.mdAdded by AutoGineer881 B
- LICENSELicence file added by AutoGineer1.1 KiB
- SKILL.md16.1 KiB
- apm.yml642 B
- references/authoring-part-02.md14.6 KiB
- references/authoring-part-03.md16.0 KiB
- references/authoring-part-04.md15.9 KiB
- references/authoring.md16.8 KiB
- references/authoring/authoring-workflows.md11.7 KiB
- references/authoring/bookmark.md14.3 KiB
- references/authoring/button-part-02.md16.1 KiB
- references/authoring/button-part-03.md7.7 KiB
- references/authoring/button.md15.7 KiB
- references/authoring/card-part-02.md16.1 KiB
- references/authoring/card-part-03.md8.6 KiB
- references/authoring/card.md6.4 KiB
- references/authoring/cartesian-part-02.md17.7 KiB
- references/authoring/cartesian-part-03.md12.3 KiB
- references/authoring/cartesian-part-04.md15.8 KiB
- references/authoring/cartesian.md18.0 KiB
- references/authoring/color-strategy.md8.4 KiB
- references/authoring/conditional-formatting-part-02.md13.5 KiB
- references/authoring/conditional-formatting-part-03.md16.0 KiB
- references/authoring/conditional-formatting-part-04.md14.0 KiB
- references/authoring/conditional-formatting-part-05.md16.9 KiB
- references/authoring/conditional-formatting-part-06.md14.7 KiB
- references/authoring/conditional-formatting-part-07.md14.5 KiB
- references/authoring/conditional-formatting.md18.2 KiB
- references/authoring/custom-visuals.md13.9 KiB
- references/authoring/expressions.md11.9 KiB
- references/authoring/field-parameters.md5.1 KiB
- references/authoring/filter-pane.md5.0 KiB
- references/authoring/filters.md9.3 KiB
- references/authoring/formatting-overview.md4.8 KiB
- references/authoring/formatting-part-02.md3.3 KiB
- references/authoring/formatting.md17.0 KiB
- references/authoring/image.md12.6 KiB
- references/authoring/kpi.md2.5 KiB
- references/authoring/map.md13.4 KiB
- references/authoring/model-binding.md7.7 KiB
- references/authoring/page-formatting.md4.5 KiB
- references/authoring/powerbi-desktop.md2.4 KiB
- references/authoring/powerbi-report-author-cli-part-02.md3.2 KiB
- references/authoring/powerbi-report-author-cli.md17.7 KiB
- references/authoring/preview-part-02.md16.9 KiB
- references/authoring/preview-part-03.md4.0 KiB
- references/authoring/preview-part-04.md2.5 KiB
- references/authoring/preview.md16.1 KiB
- references/authoring/re-theming-part-02.md16.8 KiB
- references/authoring/re-theming-part-03.md4.9 KiB
- references/authoring/re-theming.md1.5 KiB
- references/authoring/screenshot-review.md5.0 KiB
- references/authoring/shape.md13.6 KiB
- references/authoring/slicers-part-02.md16.3 KiB
- references/authoring/slicers.md15.6 KiB
- references/authoring/table.md17.5 KiB
- references/authoring/textbox.md5.6 KiB
- references/authoring/theming-part-02.md6.7 KiB
- references/authoring/theming.md16.4 KiB
- references/authoring/version-control.md6.6 KiB
- references/design.md17.3 KiB
- references/design/accessibility.md11.4 KiB
- references/design/anti-patterns.md18.5 KiB
- references/design/archetype-composition.md3.4 KiB
- references/design/archetypes/analytical-canvas.md17.7 KiB
- references/design/archetypes/comparative-benchmark-part-02.md5.7 KiB
- references/design/archetypes/comparative-benchmark.md15.8 KiB
- references/design/archetypes/executive-summary.md14.7 KiB
- references/design/archetypes/narrative-story.md18.1 KiB
- references/design/archetypes/operational-monitor.md17.0 KiB
- references/design/assets/base.json7.5 KiB
- references/design/brownfield.md5.7 KiB
- references/design/chart-selection.md9.8 KiB
- references/design/color.md10.5 KiB
- references/design/design-brief-part-02.md13.7 KiB
- references/design/design-brief.md8.8 KiB
- references/design/interactivity.md9.2 KiB
- references/design/layout.md11.3 KiB
- references/design/pre-flight-checklist.md10.8 KiB
- references/design/signatures.md12.3 KiB
- references/design/tone-catalog.md14.4 KiB
- references/design/typography.md9.2 KiB
- references/design/visual-cookbook-part-02.md11.0 KiB
- references/design/visual-cookbook.md16.7 KiB
- references/management-part-02.md17.2 KiB
- references/management-part-03.md7.5 KiB
- references/management-part-04.md16.7 KiB
- references/management.md10.1 KiB
- references/planning-part-02.md11.2 KiB
- references/planning.md19.5 KiB
references/authoring/theming.md
Theme Authoring — theme.json Reference
Referenced from SKILL.md. Read formatting-overview.md (see
formatting-overview.md) first for the cascade model. Read this when creating or editing a Power BI custom theme JSON file. Theme files live inStaticResources/RegisteredResources/within the report.
Table of Contents
Registering a Custom Theme
Theme Name GUID Convention (Cache-Busting)
Schema Version
Theme JSON Anatomy
1. Data Colors (
dataColors)2. Sentiment Colors
3. Gradient Defaults
4. Structural Colors
5. Text Classes (
textClasses)6. Visual Styles (
visualStyles)7. Style Presets
ThemeDataColor Resolution — continued in
theming-part-02.md
Theme Defaults for Page Objects — continued in
theming-part-02.md
Custom Icons — continued in
theming-part-02.md
Re-theming & Dark Mode — continued in
theming-part-02.mdTheme Authoring Best Practices — continued in
theming-part-02.mdCommon Pitfalls — continued in
theming-part-02.md
Registering a Custom Theme
A custom theme requires two entries in report.json:
themeCollection.customTheme— references the theme by name and type:
"customTheme": {
"name": "MyTheme-a1b2c3d4.json",
"reportVersionAtImport": { "visual": "...", "report": "...", "page": "..." },
"type": "RegisteredResources"
}resourcePackages[]— registers the file so Desktop can locate it:
{
"name": "RegisteredResources",
"type": "RegisteredResources",
"items": [{
"name": "MyTheme-a1b2c3d4.json",
"path": "MyTheme-a1b2c3d4.json",
"type": "CustomTheme"
}]
}Theme Name GUID Convention (Cache-Busting)
Power BI Desktop caches themes by name. To guarantee that every theme edit is picked up on reload, append a short GUID suffix to the theme filename:
<CustomThemeName>-<guid>.json<CustomThemeName>— the user-provided name (e.g.,DarkCoralTheme) or the name you choose if the user doesn't specify one. Once established, the<CustomThemeName>is stable — it does NOT change when the theme content is updated (even if the palette changes entirely). Only change<CustomThemeName>if the user explicitly asks to rename the theme.<guid>— a freshly generated short GUID (8–12 hex chars is sufficient, e.g.,a1b2c3d4). Use a full UUID without dashes truncated to 8+ chars, or any unique random hex string.
Examples:
User says "call it DarkCoralTheme" →
DarkCoralTheme-f7e2a91c.jsonYou choose the name →
ExecutiveDark-3bc04d8e.jsonUser later says "change to light green palette" → keep the same
<CustomThemeName>, only rotate the GUID:DarkCoralTheme-e4f5a6b7.json(content changes,<CustomThemeName>stays)User says "change the theme to dark orange" → this is a palette/style change, NOT a rename. Keep the same
<CustomThemeName>, only rotate the GUID and update content. Phrases like "change the theme to X" or "apply a X theme" describe the desired appearance — they are NOT rename requests.User says "rename the theme to LightGreen" → now change
<CustomThemeName>:LightGreen-e4f5a6b7.json
On every custom theme file update — any change to
StaticResources/RegisteredResources/<CustomThemeName>-<guid>.json, regardless
of what changed (colors, fonts, visualStyles, metadata, schema, whitespace, or
any other content):
Generate a new GUID. Keep the same
<CustomThemeName>— do NOT change it unless the user explicitly requests a rename.Edit the theme file content in place — update colors, fonts,
visualStyles, and update the"name"field inside the JSON to match the new filename (e.g.,"DarkCoralTheme-e4f5a6b7.json").Rename the file from
<CustomThemeName>-<oldGUID>.jsonto<CustomThemeName>-<newGUID>.jsonusing a filesystem rename (Rename-Item/mv) — do NOT create a new file and delete the old one; rename is equivalent and avoids a redundant write + delete.Update all references in
report.json:themeCollection.customTheme.nameresourcePackages[].items[].nameresourcePackages[].items[].path
Reload Desktop — the new filename guarantees cache invalidation.
Why? Desktop's theme engine caches by filename. Editing a file in place with the same name can leave stale theme state even after reload. Changing the filename on every update forces a fresh load every time.
Important: Inside
report.json, bothcustomTheme.nameand the matchingresourcePackages[].items[].nameMUST include the.jsonextension (e.g.,"MyTheme-a1b2c3d4.json") and MUST equal the item'spath. Using the bare theme name (e.g.,"MyTheme-a1b2c3d4") causes the published report on the Power BI service to incorrectly apply the theme because the resource mapping never matches the file underStaticResources/RegisteredResources/.The
pathmust be the filename only (e.g.,"MyTheme-a1b2c3d4.json") with the.jsonextension. Do NOT include directory prefixes like"RegisteredResources/MyTheme-a1b2c3d4.json"— this causes Desktop to silently ignore the theme.The
namefield inside the theme JSON file itself MUST matchcustomTheme.name/resourcePackages[].items[].nameexactly, including the.jsonextension (e.g.,"MyTheme-a1b2c3d4.json"). Using a bare name such as"MyTheme-a1b2c3d4"causes validation failure and can break Desktop theme loading.Run
powerbi-report-author validate <path-to-.Report-dir>after registering or editing a theme to catch registration and theme JSON issues before following the host-specific workflow in preview.md (seepreview.md).
Schema Version
Set "$schema" to a published reportThemeSchema-<major>.<minor>.json from the
powerbi-desktop-samples repo.
How to choose the version:
Check Microsoft's base themes first. Scan
<Report>/StaticResources/SharedResources/BaseThemes/*.jsonfor any file that carries a"$schema". If found, reuse the same version — those files are shipped by Power BI Desktop and represent the version it currently understands.No
"$schema"in any base theme (the common case today, since the shipped base themes don't pin one) — use the latest publishedreportThemeSchema-<version>.jsonfrom the samples repo above.
Reference the schema as a full published HTTPS URL or as a local
reportThemeSchema-<version>.json placed beside the theme JSON.
Theme JSON Anatomy
A custom theme has 7 sections. All use plain JSON encoding (no PBIR expression wrappers):
{
"name": "MyTheme-a1b2c3d4.json",
"dataColors": ["#118DFF", "#12239E", "#E66C37", ...],
"good": "#1AAB40",
"neutral": "#D9B300",
"bad": "#D64554",
"maximum": "#118DFF",
"center": "#D9B300",
"minimum": "#DEEFFF",
"null": "#FF7F48",
"foreground": "#252423",
"background": "#FFFFFF",
"tableAccent": "#118DFF",
"textClasses": { ... },
"visualStyles": { ... },
"icons": { ... }
}1. Data Colors (dataColors)
An array of hex strings defining the categorical color palette:
"dataColors": [
"#118DFF", "#12239E", "#E66C37", "#6B007B", "#E044A7",
"#744EC2", "#D9B300", "#D64550", "#197278", "#1AAB40"
]Indexed by
ThemeDataColor.ColorId(0-based) in PBIR formattingThe default base theme has 41 colors
Custom
dataColorsfully replaces the base theme array (no merge)When exhausted, PBI generates unique colors via saturation/hue shifts
2. Sentiment Colors
Used by waterfall charts and KPI visuals:
| Key | Purpose | Default |
|---|---|---|
good | Positive values | #1AAB40 (green) |
neutral | Neutral values | #D9B300 (yellow) |
bad | Negative values | #D64554 (red) |
3. Gradient Defaults
Default colors for the conditional formatting color-scale dialog:
| Key | Purpose | Default |
|---|---|---|
maximum | Highest value | #118DFF |
center | Middle value (diverging) | #D9B300 |
minimum | Lowest value | #DEEFFF |
null | Null values | #FF7F48 |
These keys only seed/default the color-scale picker. Custom theme JSON does not author conditional formatting rules; apply rules on the target visual.
4. Structural Colors
Foundational UI colors. The 7 classes (with legacy aliases):
| Preferred Name | Alias | What It Formats |
|---|---|---|
firstLevelElements | foreground | Labels, trend lines, textbox defaults, card data labels, slicer item color |
secondLevelElements | foregroundNeutralSecondary | Legend labels, axis labels, table headers, gauge target |
thirdLevelElements | backgroundLight | Gridlines, table grid, slicer header background, shape fill |
fourthLevelElements | foregroundNeutralTertiary | Legend dimmed, card category labels, funnel conversion rate |
background | — | Label background, slicer dropdown, donut stroke, button fill, tooltip bg |
secondaryBackground | backgroundNeutral | Table grid outline, shape map default, ribbon fill, disabled button |
tableAccent | — | Table and matrix grid outline |
⚠️ Dark themes: ALL structural colors must be adjusted together.
Setting background to dark without adjusting firstLevelElements makes text invisible.
Additionally, the filter pane does NOT inherit from structural colors —
you must always explicitly set outspacePane and filterCard in
visualStyles["*"]["*"] when changing themes. See re-theming.md § Dark Mode Authoring Checklist (see re-theming-part-03.md, section dark-mode-authoring-checklist)
for the complete checklist (filter pane, stylePreset override, fillCustom+id selector, objects vs VCO).
5. Text Classes (textClasses)
4 primary classes (editable in Customize Theme dialog):
| Class | Key | Default Font | Default Size | Used By |
|---|---|---|---|---|
| General | label | Segoe UI | 10pt | Table/matrix values, slicer items |
| Title | title | DIN | 12pt | Axis titles, multi-row card title |
| Cards & KPIs | callout | DIN | 45pt | Card data labels, KPI indicators |
| Tab headers | header | Segoe UI Semibold | 12pt | Key influencers headers |
8 documented derived classes (auto-derived from primaries):
| Key | Derives From | Modification |
|---|---|---|
largeTitle | title | 14pt — visual title |
semiboldLabel | label | Segoe UI Semibold — key influencers profile |
largeLabel | label | 12pt — multi-row card data |
smallLabel | label | 9pt — reference lines, slicer date range |
lightLabel | label | Color from secondLevelElements — legend, button text, axis labels |
boldLabel | label | Segoe UI Bold — matrix subtotals, table totals |
largeLightLabel | label | secondLevelElements color, 12pt — card category, gauge labels |
smallLightLabel | label | secondLevelElements color, 9pt — data labels, value axis labels |
Other textClasses names may appear in exported PBIR or undocumented schema
variants, but they are not documented in Microsoft's theme guidance. Do not
author them unless you have validated the current reportThemeSchema.json for
the target Desktop version.
Format:
"textClasses": {
"callout": { "fontSize": 45, "fontFace": "DIN", "color": "#252423" },
"title": { "fontSize": 12, "fontFace": "DIN", "color": "#252423" },
"header": { "fontSize": 12, "fontFace": "Segoe UI Semibold", "color": "#252423" },
"label": { "fontSize": 10, "fontFace": "Segoe UI", "color": "#252423" }
}Properties: fontFace (string), fontSize (number, pt), color (hex string).
Optional: "bold": true.
6. Visual Styles (visualStyles)
Sets default formatting for any visual type — the central mechanism for theme-driven appearance.
Three-Level Hierarchy
visualStyles[Level 1: visual type][Level 2: style preset][Level 3: object name] → properties| Level | Examples | Wildcard |
|---|---|---|
| 1 — Visual type | "barChart", "tableEx", "pivotTable" | "*" = all types |
| 2 — Style preset | "Bold", "Minimal", "Corporate" | "*" = default (no preset) |
| 3 — Object name | "legend", "dataPoint", "border" | "*" = all objects |
Resolution order (first match wins):
customTheme.visualStyles[exactType][activePreset][object]customTheme.visualStyles[exactType]["*"][object]customTheme.visualStyles["*"][activePreset][object]customTheme.visualStyles["*"]["*"][object]baseTheme.visualStyles[exactType]["*"][object]baseTheme.visualStyles["*"]["*"][object]System defaults
Type-specific entries override wildcard entries at each level.
Example — Universal + Type-Specific
"visualStyles": {
"*": {
"*": {
"title": [{
"show": true,
"fontFamily": "'Segoe UI Semibold'",
"fontSize": 12,
"fontColor": { "solid": { "color": "#333333" } }
}],
"background": [{
"show": true,
"color": { "solid": { "color": "#FFFFFF" } },
"transparency": 0
}],
"border": [{
"show": true,
"color": { "solid": { "color": "#E0E0E0" } },
"radius": 4,
"width": 1
}]
}
},
"barChart": {
"*": {
"border": [{ "radius": 8 }],
"legend": [{ "position": "Top" }]
}
}
}Encoding in visualStyles
Values use theme encoding (plain JSON), not PBIR expression wrappers:
"show": true,
"fontSize": 12,
"position": "Top",
"fontColor": "#252423",
"gridlineColor": { "solid": { "color": "#E0E0E0" } }Color properties: Some accept plain hex strings, others require
{ "solid": { "color": "#hex" } }. When in doubt, use the structured format.
Object Names for visualStyles
Common objects available under "*" (all types):
title, subTitle, background, border, dropShadow, visualHeader,
visualTooltip, lockAspect, general, padding, divider, spacing
Per-visual-type objects (examples):
| Visual Type | Objects |
|---|---|
| Column/Bar | categoryAxis, valueAxis, legend, dataPoint, labels |
| Line/Area | categoryAxis, valueAxis, legend, dataPoint, labels, lineStyles, markers |
Table (tableEx) | grid, columnHeaders, values, total, columnFormatting, stylePreset |
Matrix (pivotTable) | grid, columnHeaders, rowHeaders, values, subTotals, grandTotal |
| Slicer | data, selection, header, items, slider |
| Card | labels, categoryLabels, wordWrap |
Use powerbi-report-author formatting list-objects <type> for the full list per visual.
The $id Property — Instance Discrimination
Some objects have multiple instances discriminated by $id:
"filterCard": [
{ "$id": "Applied", "backgroundColor": { "solid": { "color": "#E8F0FE" } } },
{ "$id": "Available", "backgroundColor": { "solid": { "color": "#FFFFFF" } } }
]This is the theme-level equivalent of PBIR's "selector": { "id": "..." }.
Both use PascalCase values ("Applied", "Available").
7. Style Presets
Style presets are named formatting bundles selectable per-visual.
Theme-Side: Registration
Register presets in visualStyles at level 2:
"visualStyles": {
"columnChart": {
"*": {
"stylePreset": [{ "name": "Corporate Blue" }],
"legend": [{ "position": "BottomCenter" }]
},
"Corporate Blue": {
"legend": [{ "position": "Right", "fontColor": { "solid": { "color": "#003366" } } }]
},
"Minimal": {
"legend": [{ "show": false }],
"border": [{ "show": false }]
}
}
}Visual-Side: Selection
Each visual selects its preset via the stylePreset VCO (PBIR encoding):
"visualContainerObjects": {
"stylePreset": [{
"properties": {
"name": { "expr": { "Literal": { "Value": "'Corporate Blue'" } } }
}
}]
}If no stylePreset VCO is present, the "*" (default) preset applies.
Limitations
Per-visual-type only — presets can't span visual types
No UI dropdown for custom presets yet (built-in presets only)
Preset names are arbitrary strings (title-case convention:
"Bold","Minimal")
Requirements and compatibility
Works with: Claude Code, Claude apps, OpenAI Codex, GitHub Copilot, Cursor, Gemini CLI, Kiro, OpenCode, Goose, Amp, Roo Code, JetBrains Junie, Factory Droid, Devin (ex-Windsurf), Mistral Vibe, OpenHands, Letta
“Works with” means the tool reads the open Agent Skills format; a skill written for one tool may use features others lack.
Security
What our scanner noticed· Low risk
- Phrasing that asks for actions without confirmation
- Instructions that use the network
A static scan is not a guarantee. Skills are third-party content: review a skill before you let an agent use it.
Attribution and licence
- Published by
- Microsoft
- Publisher
- Microsoft (Official)
- Source
- microsoft/skills-for-fabric · skills/powerbi-report-cli · commit f8fac11
- Licence
- MIT License (redistribution allowed)
- LICENSE (added by AutoGineer from LICENSE)
- ATTRIBUTION.md (written by AutoGineer)
- Synced
- Also distributed in
- microsoft/skills-for-fabric
AutoGineer is not affiliated with or endorsed by Microsoft.
Download ZIP
The ZIP holds the skill’s files, its licence files and an ATTRIBUTION.md. Download powerbi-report-cli.zip