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://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/button-part-02.md
Button Visual Authoring Guide - Part 2
Contents
Action Types
Data Function (translytical task flow)
Formatting Objects
Dual-Entry Pattern (Required)
State Selectors
Conditional Formatting (Data-Driven Color)
Shape Options
Icon Options
Continuation of button.md. Open this file directly from the skill reference index.
Action Types
Actions are set via visualContainerObjects.visualLink. Discover this VCO and
its properties with
powerbi-report-author formatting search actionButton "type|link". The type
property determines the action; a companion property configures the destination.
Commonly used action types:
| Action Type | type Value | Additional Properties | Use Case |
|---|---|---|---|
| Back | 'Back' | — | Return to previous page (drillthrough) |
| Page Navigation | 'PageNavigation' | navigationSection: '<pageId>' | Navigate to a specific page |
| Bookmark | 'Bookmark' | bookmark: '<bookmarkName>' | Apply a bookmark state |
| Drillthrough | 'Drillthrough' | drillthroughSection: '<pageId>' | Navigate with filter context |
| Web URL | 'WebUrl' | webUrl: '<url>' | Open external link |
| Q&A | 'Qna' | — | Open Q&A explorer |
| Apply All Slicers | 'ApplyAllSlicers' | — | Apply pending slicer selections |
| Clear All Slicers | 'ClearAllSlicers' | — | Reset all slicers on page |
| Data Function | 'DataFunction' | dataFunction: structured item reference (see Data Function) | Invoke a Fabric User Data Function (translytical task flow) |
Page Navigation example:
"visualLink": [{
"properties": {
"show": { "expr": { "Literal": { "Value": "true" } } },
"type": { "expr": { "Literal": { "Value": "'PageNavigation'" } } },
"navigationSection": { "expr": { "Literal": { "Value": "'<target_page_id>'" } } },
"tooltip": { "expr": { "Literal": { "Value": "'Go to Details'" } } }
}
}]Web URL example:
"visualLink": [{
"properties": {
"show": { "expr": { "Literal": { "Value": "true" } } },
"type": { "expr": { "Literal": { "Value": "'WebUrl'" } } },
"webUrl": { "expr": { "Literal": { "Value": "'https://example.com'" } } }
}
}]Data-driven Web URL.
webUrlalso accepts a measure returning a URL string:"webUrl": { "expr": { "Measure": { "Expression": { "SourceRef": { "Entity": "Metrics" } }, "Property": "Btn URL" } } }. See conditional-formatting.md § Buttons and shapes (seeconditional-formatting-part-03.md, sectionbuttons-and-shapes).
Note: The companion property (
navigationSection,drillthroughSection,bookmark) is the raw page id or bookmark name as a string literal. The validator cross-checks bookmark action targets againstdefinition/bookmarks/; a missing destination is reported asPBIR_BOOKMARK_ACTION_REF_MISSINGbefore Desktop reload. See bookmark.md (seebookmark.md).
Data Function (translytical task flow)
A DataFunction button invokes a published Fabric User Data Function (UDF) —
a translytical task flow that runs server-side logic (e.g. Python write-back).
Unlike the other action types, its companion dataFunction property is not a
string literal: it is a structured item reference to the UDF plus a cached
copy of the function signature and the button's parameter bindings.
Structure:
"visualLink": [{
"properties": {
"show": { "expr": { "Literal": { "Value": "true" } } },
"type": { "expr": { "Literal": { "Value": "'DataFunction'" } } },
"tooltip": { "expr": { "Literal": { "Value": "'Run data function'" } } },
"dataFunction": {
"kind": "ItemLocation",
"byReference": {
"itemId": { "expr": { "Literal": { "Value": "'<userDataFunctions_item_id>'" } } },
"workspaceId": { "expr": { "Literal": { "Value": "'<workspace_id>'" } } }
},
"metadata": {
"dataFunction": {
"name": "<function_name>",
"autoRefresh": true,
"parameters": [
{
"name": "<param_name>",
"dataType": "string",
"isOptional": false,
"defaultValue": null,
"type": "SlicerParameter",
"slicer": "<slicer_visual_name>",
"autoClear": false
}
]
}
}
}
}
}]Field reference:
| Field | Meaning | How to obtain |
|---|---|---|
byReference.workspaceId | GUID of the workspace holding the UDF (the Workspace dropdown in Desktop) | Resolve workspace name → id (see SKILL.md CRITICAL NOTES (see ../authoring.md, section critical-notes): list workspaces + JMESPath filter) |
byReference.itemId | GUID of the UserDataFunctions item — the Function set dropdown | List items of type UserDataFunctions in the workspace → id (SKILL.md CRITICAL NOTES (see ../authoring.md, section critical-notes)) |
metadata.dataFunction.name | The function within the item — the Data function dropdown | From the UDF definition, or ask the user |
metadata.dataFunction.parameters[] | Cached copy of the function's parameter signature, each with its binding to a report element | From the UDF signature; bind each parameter to an input on the page |
The GUIDs use the standard expr → Literal → Value envelope (single-quoted
string), same as every other literal in PBIR — so once the ids are resolved, the
reference is authored exactly like any other property.
Parameter bindings — each parameters[] entry copies the UDF parameter
(name, dataType, isOptional, defaultValue) and adds how the button feeds
it a value. General rule: every required parameter (isOptional: false,
no defaultValue) must be bound to some input source on the page; optional
parameters (isOptional: true, with a defaultValue) can be left unmapped and
the function's default is used. If every parameter is optional, the button needs
no input control at all.
Per the translytical task flow docs,
a parameter's input source can be a slicer (button, list, or input/text
slicer), a data field (a column in the Data pane), or a measure
(e.g. SELECTEDVALUE(Customer[CustomerID]) to pass a single value). The type
field on the parameters[] entry selects which source is used; author it to
match the input you intend to bind.
Example — binding a parameter to a slicer (type: "SlicerParameter"):
{
"name": "<param_name>",
"dataType": "string",
"isOptional": false,
"defaultValue": null,
"type": "SlicerParameter",
"slicer": "<slicer_visual_name>",
"autoClear": false
}slicer is the target slicer visual's name (its visuals/<name> folder);
autoClear controls whether the slicer resets after the function runs; the bound
slicer must exist on the page for the button to enable. For a field or
measure source the entry uses a different type and binding property —
inspect a button authored in Desktop to capture the exact parameters[] shape
before hand-writing it.
Authoring flow:
Inspect the UDF signature. For each required parameter, choose an input source (slicer / field / measure); optional parameters may be skipped.
Ensure each chosen input exists on the page (e.g. for a slicer source, note its visual
name).Resolve
workspaceIdand theUserDataFunctionsitemId(SKILL.md CRITICAL NOTES (see../authoring.md, sectioncritical-notes): list items + JMESPath filter).Author the button
visual.jsonwithtype: 'DataFunction'and thedataFunctionblock above — oneparameters[]entry per bound UDF parameter, each with thetypeand binding property for its source.Publish the report — the Fabric service executes the function when the button is clicked.
Runtime note: The referenced UDF must return a string. If the item reference or a required parameter's bound input (slicer/field/measure) is missing or invalid, the button still validates but stays disabled at runtime.
Formatting Objects
List the objects and which require selectors with
powerbi-report-author formatting list-objects actionButton, and read each
object's properties, types, and valid selector IDs (_selectorHint) with
powerbi-report-author formatting describe-object actionButton <object>.
Two things the CLI does not surface:
shapeneeds adefault-selector entry to render — see Shape Options.rotationtakes no selector — author its properties in a single no-selector entry.
Dual-Entry Pattern (Required)
Button formatting objects use a dual-entry array pattern:
Entry 1 (no selector): Toggle properties (
show) — applies to ALL statesEntry 2 (with state selector): Styling properties — applies to that specific state
"fill": [
{ "properties": { "show": { "expr": { "Literal": { "Value": "true" } } } } },
{ "properties": { "fillColor": { "solid": { "color": { "expr": { "Literal": { "Value": "'#0078D4'" } } } } } }, "selector": { "id": "default" } }
]⚠️ Putting all properties in one entry (with or without selector) causes formatting to silently fail. The button renders with defaults — no fill, no text color, no icon styling. Always separate
showfrom styling properties.
Exceptions:
outlinewithshow: false— can be a single unselectored entry (nothing to style)rotation— never takes a selector; author all rotation properties in one no-selector entry (unlikeshape, it does not need adefault-selector entry).shape— uses a two-entry pattern, but different from theshow/style split above (there is noshowtoggle). See Shape Options.
shadowandglowfollow the standard dual-entry rule — do not treat them likerotation. They are effect objects with ashowtoggle and a state selector, soshowgoes in Entry 1 (no selector) and the styling (color,shadowBlur,shadowPositionPreset,shadowDistance,angle) in Entry 2 (selector: { "id": "default" }). Puttingshowinside thedefault-selector entry (or cramming everything into one selectored entry) leaves the object toggled off in the format pane and not rendered — the effect silently never appears. This is the same failure as thefillexample above.
State Selectors
Stateful objects accept a { "id": "<state>" } selector on each styling entry.
Read the valid state IDs for an object from its _selectorHint
(describe-object). The enum names don't spell out what each state means:
| Selector ID | State | When active |
|---|---|---|
"default" | Normal/resting | Not hovered or pressed |
"hover" | Mouse over | Cursor is on the button |
"selected" | Pressed/active | Button is clicked/held |
"disabled" | Inactive | Button action unavailable |
shapeis state-selectable too — the CLI does not show it. In Desktop the Shape card has an "Apply settings to → State" dropdown, and per-stateshapeentries render correctly (e.g. adefaulthexagon that becomes anovalon hover), verified by Desktop render. Butdescribe-object actionButton shapecurrently returns no_selectorHint, so the CLI understates it — treatshape(includingtileShape) as accepting the samedefault/hover/selected/disabledselectors asfill/text/outline.The
disabledstate only appears when the button's action is genuinely unavailable — the only reliable trigger is aDrillthroughbutton with no data point selected. A button with an always-available action can authordisabledstyling but will never display it.
Add one styling entry per state:
"fill": [
{ "properties": { "show": { "expr": { "Literal": { "Value": "true" } } } } },
{ "properties": { "fillColor": { "solid": { "color": { "expr": { "Literal": { "Value": "'#0078D4'" } } } } } }, "selector": { "id": "default" } },
{ "properties": { "fillColor": { "solid": { "color": { "expr": { "Literal": { "Value": "'#005A9E'" } } } } } }, "selector": { "id": "hover" } }
]Only the default state renders on the Edit-view canvas and in screenshot-all;
hover/selected show only in Reading view or via the Format pane's state
dropdown. A button whose action is unavailable renders in its disabled state
automatically.
Conditional Formatting (Data-Driven Color)
Button color properties, the text label (text.text), and the Web URL action
target support data-driven formatting. See
conditional-formatting.md § Buttons and shapes (see conditional-formatting-part-03.md, section buttons-and-shapes)
for the supported properties, styles (field value / rules / gradient), selector
requirements, limits, and examples.
Shape Options
Set via objects.shape using a two-entry array. This is required for the
shape to actually render — a single selector-less entry passes validation but
Power BI Desktop silently renders a flat rectangle regardless of tileShape.
Entry 1 (no selector):
tileShape+ any shape-specific geometry params (roundEdge,parallelogramSlant,speechBubbleHeight, etc.).Entry 2 (
selector: { "id": "default" }):tileShapeonly — this is the entry Desktop reads to select the rendered shape.
"shape": [
{ "properties": { "tileShape": { "expr": { "Literal": { "Value": "'parallelogram'" } } }, "parallelogramSlant": { "expr": { "Literal": { "Value": "20L" } } } } },
{ "properties": { "tileShape": { "expr": { "Literal": { "Value": "'parallelogram'" } } } }, "selector": { "id": "default" } }
]Keep geometry params in Entry 1 and only tileShape in the default entry —
this matches Power BI's own serialization so the file round-trips cleanly. Get
the tileShape enum values and each shape's geometry params (all integer
literals, e.g. 20L) from
powerbi-report-author formatting describe-object actionButton shape.
Non-rectangular shapes seat the label in a non-rectangular region — centered white text can overrun the colored area and vanish on the canvas. There is no sizing formula for this; handle it via shape choice,
text.horizontalAlignment, short labels, and a render check — see Button Sizing Step 2 and Step 5.
⚠️ Never author
tileShape: 'line'. The enum includes'line', but it is a phantom — not offered in Desktop's Shape dropdown, renders as a near-invisible thin rule, and crashes the Desktop format pane when the button is selected. The CLI cannot flag this; exclude it yourself.
Icon Options
Set via objects.icon with a { "id": "default" } selector. Get the shapeType
enum (built-in glyphs) and placement enum from
powerbi-report-author formatting describe-object actionButton icon.
Behavioral facts the CLI does not surface:
shapeType: 'blank'renders no icon (label only).iconSizeis a numeric point size (Double, e.g.28D), not an integer literal.shapeType: 'custom'sets the iconimageto a registered resource — add the raster underStaticResources/RegisteredResources/, list it in the report'sresourcePackages, and pointimage.urlat that resource path. Prefer a built-inshapeTypeglyph when one fits; only usecustomwhen you have a real registered raster. Avoid inlinedata:URIs — they may author and validate (schema checks are skipped when the schema is unreachable) but can fail to render or destabilize Desktop.
Dual-entry for icon: put icon.show in the first no-selector entry and the
styling (shapeType, placement, lineColor, iconSize, image) in a
{ "id": "default" } entry — same split as fill/text:
"icon": [
{ "properties": { "show": { "expr": { "Literal": { "Value": "true" } } } } },
{ "properties": { "shapeType": { "expr": { "Literal": { "Value": "'information'" } } }, "placement": { "expr": { "Literal": { "Value": "'left'" } } } }, "selector": { "id": "default" } }
]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 or Microsoft.
Download ZIP
The ZIP holds the skill’s files, its licence files and an ATTRIBUTION.md. Download powerbi-report-cli.zip