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/re-theming-part-02.md
Re-theming & Dark Mode — Workflow Reference - Part 2
Contents
Re-theming an Existing Report
Why Theme Changes Don't Fully Propagate
Re-theming Workflow
Preventive Authoring: Theme-Adaptive Visuals
Continuation of re-theming.md. Open this file directly from the skill reference index.
Re-theming an Existing Report
When switching a report to a new theme (especially light → dark or dark → light),
changing theme.json alone is not sufficient if visuals have per-visual
objects or visualContainerObjects color properties. Those per-visual colors
override the theme cascade and remain unchanged.
Why Theme Changes Don't Fully Propagate
The formatting cascade (formatting-overview.md) resolves as:
Priority 1: Conditional formatting ← highest, always wins
Priority 2: Per-visual objects ← overrides theme
Priority 3: Visual container objects (VCO) ← overrides theme
Priority 4: Page objects
Priority 5: Theme visualStyles[type] ← only applies if no per-visual override
Priority 6: Theme visualStyles["*"]
Priority 7: Base theme
Priority 8: System defaultsIf a visual has any explicit objects or visualContainerObjects color
properties, those win over the new theme. The visual appears unchanged
despite the theme switch.
Key insight: If an objects group has even ONE explicit property (e.g.,
columnAdjustment: 'growToFit'), ALL color properties in that same group
stop inheriting from the theme. You must add/update explicit colors for
every property in that group.
Re-theming Workflow
⚠️ POLARITY CHANGE GATE — Read this FIRST: Determine whether the theme switch changes polarity (dark → light or light → dark). A polarity change means foreground/text colors that were designed for contrast against the old background MUST flip too:
Dark → Light: Light text (
#F9FAFB,#E6EDF3,#FFFFFF) → dark text (#1F2937,#252423,#333333)Light → Dark: Dark text (
#1F2937,#252423,#333333) → light text (#F9FAFB,#E6EDF3,#FFFFFF)These foreground colors are hardcoded as
Literalvalues on shapes, textboxes, slicer items/headers, card values, and nav buttons. The theme cascade does NOT override them. If you omit foreground colors from your color mapping and sweep, text becomes invisible — light-on-light or dark-on-dark.Same-polarity switches (dark → dark, light → light) may share foreground values, but include them in the mapping when they differ — different text shades produce a more cohesive result. The sweep of accent/background colors is always needed — shapes, nav buttons, accent bars, and chart borders commonly hardcode
dataColors[0]and other accent hex values as Literal fills/outlines that do not auto-resolve via the theme cascade.
Step 0: Build a color mapping table
Before touching any files, extract all hex colors from the old theme JSON and map each to its replacement in the new theme. Include ALL categories:
Foreground/text colors (
foreground,firstLevelElements,secondLevelElements,textClassescolors) — critical for polarity changes (visibility), but also include for same-polarity changes when the new theme uses different text shades for a more cohesive resultStructural colors (
background,secondaryBackground,thirdLevelElements)dataColorsarray (index-by-index) — CRITICAL even for same-polarity changes. Shapes, nav buttons, accent bars, and chart borders commonly hardcodedataColors[0..N]hex values as Literal fills/outlines. These do NOT auto-resolve viaThemeDataColoror the theme cascade. Grepdefinition/for every olddataColorsvalue.tableAccent,good/neutral/bad,maximum/center/minimumvisualStylescolors (borders, gridlines, accent colors, backgrounds)⚠️ Page-level background/outspace colors — these are NOT in the theme file but are hardcoded in
page.jsonfiles. For polarity switches in either direction, the page background retains the old theme's color (e.g., dark→light: a dark hex like#1A1A2Eremains; light→dark: a light hex like#FFFFFFremains). Grep allpage.jsonfiles for their currentbackgroundandoutspacecolor values and include them in the mapping. This is the second most commonly missed category after foreground text.⚠️ Slicer
items.backgroundandheader.background— on polarity changes, slicer dropdown backgrounds are hardcoded Literal values at Priority 2. Light→dark: set dark. Dark→light: set light/white. ⚠️ Slicer header.background requires SEMANTIC mapping, not accent mapping: In dark themes, slicer headers typically use a colored/accent background bar (e.g.,#3730A3) with white text. In light themes, slicer headers conventionally have a white or transparent background with dark text — NOT the new accent color. If you naively map the old dark header background to the new theme's accent color, you get a heavy colored bar that looks wrong in a light context. Map dark-theme slicerheader.backgroundto#FFFFFF(or remove the property to inherit) for dark→light changes.⚠️ Azure Map basemap style —
azureMap.objects.mapControls.defaultStyleis a hardcoded enum, not a hex color, so bulk color replacement will never update it. For polarity switches: light→dark usenight,grayscale_dark, orhigh_contrast_dark; dark→light useroadorgrayscale_light.
Old hex → New hex Category
#1F2937 → #F9FAFB FOREGROUND
#0F172A → #FFFFFF BACKGROUND
#1E293B → #F8FAFC SECONDARY BG
#3B82F6 → #2563EB ACCENT (dataColors[0])
#312E81 → #FFFFFF VISUAL CARD BG (semantic: cards are white in light themes)
#3730A3 → #FFFFFF SLICER HEADER BG (semantic: no colored bar in light themes)
#6366F1 → #BBF7D0 BORDER (semantic: soft/muted border for light themes)Extract actual hex values from the old and new theme JSON files. Every color that differs needs a row — including foreground colors when they differ between old and new themes.
⚠️ SEMANTIC ROLE AWARENESS — critical for polarity changes: Not every color maps 1:1 from old theme to new theme. Some colors serve a structural role that changes meaning across polarities:
Colored header/accent backgrounds (slicer headers, table column headers with solid fills): In dark themes these are typically mid-tone accent bars for visual separation. In light themes, the same role is usually served by white/transparent backgrounds — the accent color moves to borders or text instead. Map these to
#FFFFFFfor dark→light.Visual card backgrounds: Dark themes use dark card fills. Light themes use white (
#FFFFFF), not the new theme's background color (which is for the page canvas, not cards).Border/accent colors: Dark themes use bright borders for contrast. Light themes typically use soft/muted borders (e.g., light green
#BBF7D0instead of saturated#16A34A).Build a two-column mapping where the target color reflects the semantic role in the new polarity, not just index-matching from old→new theme properties.
Step 1: Update theme JSON AND bulk-replace all old colors (single atomic step)
Do NOT preview until this entire step is complete.
1a. Update the custom theme JSON by writing a new GUID-suffixed file —
any change to the active
StaticResources/RegisteredResources/<CustomThemeName>-<guid>.json file
requires a new GUID, regardless of what changed (colors, fonts,
visualStyles, metadata, schema, whitespace, or any other content). Do not edit
the existing GUID-suffixed theme file in place and keep the same filename.
Keep the same <CustomThemeName> — only rotate the GUID suffix per the
GUID convention in theming.md (see theming.md, section theme-name-guid-convention-cache-busting).
Do NOT rename <CustomThemeName> (e.g., DarkCoral stays DarkCoral even if
the new palette is light green) unless the user explicitly asks to rename it.
Update all report.json references to match the new GUID. For dark themes,
update ALL structural colors together (see § Structural Colors above).
1b. Bulk-replace old-theme hex values across the entire definition/
directory using the color mapping from Step 0.
Sweep category checklist — include ALL applicable rows from Step 0:
[ ] Background colors (page canvas, card/VCO backgrounds)
[ ] Secondary/tertiary background colors
[ ] Border/divider/gridline colors
[ ] Accent/data colors
[ ] Foreground/text colors — MANDATORY for polarity changes (dark↔light). These are the inline
fontColor,text.fontColor,labelColor,textRuns[].textStyle.colorvalues on shapes, slicers, cards, textboxes, and nav buttons. Omitting this category guarantees invisible text.[ ] Slicer
items.backgroundandheader.background— MANDATORY for polarity changes. Dropdown backgrounds are hardcoded Literal values that don't inherit from theme. Light→dark: set dark. Dark→light: set light. Forheader.backgroundspecifically: dark→light should map to#FFFFFF(not the new accent), because light-theme slicers use transparent/white headers. See § Semantic Role Awareness above.[ ]
#FFFFFFVCO backgrounds on all visuals — MANDATORY for light→dark.#FFFFFFhas dual meaning in light themes (card backgrounds AND text on colored shapes). Exclude it from the bulk sweep; instead scan allvisual.jsonfor#FFFFFFinvisualContainerObjects.background.colorand replace with the dark card color. Leave#FFFFFFin text contexts (shapefontColor, textboxtextRunscolor). See § 1b-extra-2 below.[ ] Azure Map
mapControls.defaultStyle— MANDATORY for polarity changes. The basemap style is an enum (night,road,grayscale_dark, etc.), not a color, so it is missed by hex sweeps.
1b-extra. Pages without explicit objects.background (polarity changes):
During polarity changes, pages that have no objects.background property
at all will default to white (system default) regardless of the theme's
background value. The bulk hex-sweep cannot fix these because there is no
color value to replace. After the bulk sweep, scan all page.json files for
pages missing objects.background entirely and add one with the new theme's
background value. See formatting-overview.md § Page Objects (see formatting-overview.md)
for the JSON structure.
1b-extra-2. Remaining #FFFFFF VCO backgrounds (light→dark):
In light themes, #FFFFFF is used for both visual card/VCO backgrounds
(which must become dark) and text colors on colored shapes/title bars
(which must stay white for contrast). The bulk hex-sweep cannot distinguish
these two roles, so #FFFFFF must be excluded from the main sweep and handled
separately.
After the bulk sweep, scan all visual.json files for #FFFFFF inside
visualContainerObjects.background.color properties and replace with the new
theme's card background color (e.g., #312E81). This applies to all visual
types — charts (donut, bar, column, line, pie, area), cards, tables, maps, and
any other visual with an explicit white VCO background.
Do NOT replace #FFFFFF in these text contexts — they need white for
contrast against colored fills:
objects.text.fontColor(shape visuals)objects.general.paragraphs[].textRuns[].textStyle.color(textboxes)visualContainerObjects.title.fontColor(when title sits on a colored bar)
Why this is commonly missed: The theme wildcard
visualStyles["*"]["*"].backgroundsets card backgrounds for visuals that inherit from theme. But visuals with any explicitvisualContainerObjects.backgroundproperty (even justshow: trueortransparency) stop inheriting — they retain whatevercolorvalue they have. In light themes that value is almost always#FFFFFF.
# Grep the report definition tree for ALL old-theme hex values (including foreground!)
grep -rn "<old.background>\|<old.secondaryBg>\|<old.border>\|<old.accent>\|<old.foreground>" <report>.Report/definition/
# Replace systematically (prefer JSON-aware tooling or edit tool over regex):
# For each old_hex → new_hex pair in the mapping, replace across all JSON files
# in definition/ — this covers pages, visuals, and VCOs in one sweep.1c. Confirm zero old-theme colors remain:
grep -rn "#EDE9FE\|#F5F3FF\|..." <report>.Report/definition/
# Expected: no matchesOnly after confirming zero matches should you proceed to Step 2.
Step 2: Audit per-visual formatting for gaps
This step catches cases the bulk sweep cannot fix — visuals that lack a color property entirely (relying on theme inheritance that may now produce wrong results) or that need new properties added.
Bulk hex-replacement is insufficient when a visual lacks a color property entirely. Shape
textobjects commonly omitfontColor(relying on theme inheritance), so a find-and-replace pass won't touch them. After bulk replacement, scan for shapes withtext.show: truethat have no explicitfontColorand add one.
Quick-reference — properties to audit per visual type:
| Visual Type | Key color properties to check | Details |
|---|---|---|
tableEx / pivotTable | columnHeaders.fontColor/backColor, values.fontColorPrimary/Secondary, values.backColorPrimary/Secondary, rowTotal.fontColor/backColor, columnTotal.fontColor/backColor | table.md (see table.md) |
cardVisual | value.fontColor, label.fontColor, fillCustom (all need { id: "default" }) | card.md (see card.md) |
| Bar/column/line charts | categoryAxis.labelColor, valueAxis.labelColor, labels.color, gridlineColor | cartesian.md (see cartesian.md) |
azureMap | mapControls.defaultStyle (enum), marker/bubble colors | map.md (see map.md) |
slicer / filterSlicer / advancedSlicerVisual | header.fontColor/background, items.fontColor/background | slicers.md (see slicers.md) |
textbox | textRuns[].textStyle.color inside paragraphs array | textbox.md (see textbox.md) |
shape | fill.color, line.color, text.fontColor (must be explicit if text.show: true) | shape.md (see shape.md) |
VCO properties to check on every visual (regardless of type):
background.color, border.color, title.fontColor, title.background,
subTitle.fontColor, divider.color, dropShadow.color,
visualHeader.background/foreground.
CLI commands for discovery:
powerbi-report-author formatting list-objects <visualType>
powerbi-report-author formatting describe-object <visualType> <objectName>Properties with type: "fill" are the ones that need color adjustment.
Critical for tables/matrices: If you set custom row colors, you MUST also set
stylePresetto'None'— otherwise the default preset overrides your colors. See table.md § Style Presets (seetable.md, sectionstyle-presets-for-tables).
Step 3: Ensure contrast and visibility
For every visual with explicit formatting, verify foreground/background contrast:
Dark background → light text; light background → dark text
Chart axis labels/legend must contrast with VCO background (or page canvas)
Slicer items must contrast with slicer body background
Chart series colors (
dataPoint.fillordataColors) must be saturated/vivid — dark/muted colors blend into dark backgrounds making bars/lines invisible
Step 4: Validate and verify
Follow the standard edit -> validate -> preview -> screenshot review loop in
preview.md (see preview.md).
Preventive Authoring: Theme-Adaptive Visuals
To minimize re-theming effort when building new reports:
Minimize explicit color properties — let the theme cascade handle defaults.
Use
ThemeDataColorreferences for adaptive colors:{ "ThemeDataColor": { "ColorId": 0, "Percent": 0.4 } }Set table/chart colors via theme
visualStyleswhen possible.Document your color mapping for systematic future switches.
Use
ThemeDataColorfor: VCObackground,border,title.fontColor,values.backColorPrimary/Secondary,columnHeaders.backColor/fontColor.Use
Literalhex for:dataPoint.fillwithmetadataselectors,FillRulegradient stops (ThemeDataColor silently breaks these).
Key insight: If an
objectsgroup exists on a visual (even for a non-color property likecolumnAdjustment), color properties in that same group will NOT inherit from the theme — you must add explicit color properties to any group that already has explicit entries. UseThemeDataColorso they stay adaptive.
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