skills.rest
weiflycc-cmd
weiflycc-cmdCOMMUNITY
Explore all skills by this author →
GitHub

powerbi-consumption-cli

Execute DAX queries against Microsoft Fabric Power BI semantic models for metadata discovery and data retrieval.

Updated Jun 1, 2026
Search Tags:#dax#power bi#semantic model#data querying#microsoft fabric#bi analytics#metadata discovery
One-click install
npx skills add https://github.com/weiflycc-cmd/skills-for-fabric --skill powerbi-consumption-cli
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: powerbi-consumption-cli
Source: https://github.com/weiflycc-cmd/skills-for-fabric/tree/main/plugins/fabric-skills/skills/powerbi-consumption-cli
Command: npx skills add https://github.com/weiflycc-cmd/skills-for-fabric --skill powerbi-consumption-cli

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill eliminates the need for manual navigation of the Power BI service to explore semantic model structure or retrieve data, enabling fast, scriptable read-only interactions with Fabric-hosted Power BI semantic models directly from your CLI environment.

Core Features & Use Cases

  • Metadata Discovery: Use DAX INFO functions to inventory tables, columns, measures, relationships, and storage details of any semantic model you have read access to.
  • Ad-Hoc Data Querying: Execute custom DAX queries to retrieve filtered, aggregated data from semantic models for analysis or validation.
  • Use Case: A data analyst can use this Skill to quickly map all measures in a sales semantic model, validate relationship cardinality, and run a DAX query to pull year-over-year sales metrics without leaving their CLI.

Quick Start

Use the powerbi-consumption-cli skill to list all tables and their hidden status in the 'Sales' semantic model in your default Fabric workspace.

Frequently Asked Questions about powerbi-consumption-cli

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query Power BI semantic models directly from the CLI?▼

Query Power BI semantic models from the CLI by executing read-only DAX queries through the Fabric MCP server. This enables direct metadata discovery and data retrieval without navigating the Power BI service interface.

Can I discover metadata like tables and measures in a Power BI semantic model without the Power BI service?▼

Discover semantic model metadata without the Power BI service by running DAX INFO.VIEW.* and INFO.* functions. This scriptable method inventories tables, columns, measures, and relationship cardinality directly.

What is the best way to run ad-hoc DAX queries for BI analytics on Microsoft Fabric?▼

Run ad-hoc DAX queries for BI analytics on Microsoft Fabric by leveraging the Fabric MCP server ExecuteQuery tool. This retrieves filtered and aggregated data for analysis or validation directly from your CLI environment.

Does querying a Power BI semantic model via DAX allow write operations or modifications?▼

Querying a Power BI semantic model via DAX does not allow write operations; it enables read-only interaction. This ensures safe exploration of semantic model structure and data validation without modifying the underlying Microsoft Fabric dataset.

Do I need direct Power BI service access to validate relationships in a semantic model?▼

Validating relationships in a semantic model does not require direct Power BI service access. You can inspect relationship cardinality and storage details using DAX INFO functions executed directly from your CLI environment.

Related Skills

Explore More Data & Analytics Skills→
patrikboroschpatrikborosch
14

powerbi-consumption-cli

Query Microsoft Fabric Power BI semantic models read-only via DAX.

Community
Intermediate
JNZader-VaultJNZader-Vault

powerbi

Develop Power BI solutions with DAX measures, Power Query transformations, and dashboard designs.

Official
Advanced
weiflycc-cmdweiflycc-cmd

powerbi-authoring-cli

Automate Power BI semantic model lifecycle in Fabric workspaces via Azure CLI REST API calls.

Community
Advanced
GabeujinGabeujin

powerbi-modeling

Guide Power BI semantic model design, DAX measures, and performance tuning.

Community
Advanced