skills.rest
patrikborosch
patrikboroschCOMMUNITY
Explore all skills by this author →
GitHub

powerbi-consumption-cli

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

14|3|Updated Mar 13, 2026
Search Tags:#data query#read-only#fabric#dax#power bi#semantic model#metadata discovery
One-click install
npx skills add https://github.com/patrikborosch/AnalyticsPlatformAgents --skill powerbi-consumption-cli-patrikborosch
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: powerbi-consumption-cli
Source: https://github.com/patrikborosch/AnalyticsPlatformAgents/tree/main/creator/skills/powerbi-consumption-cli
Command: npx skills add https://github.com/patrikborosch/AnalyticsPlatformAgents --skill powerbi-consumption-cli-patrikborosch

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill solves the challenge of safely accessing and querying Microsoft Fabric Power BI semantic models (formerly Power BI datasets) for metadata discovery and data retrieval, eliminating the risk of accidental model modifications that come with direct authoring tools.

Core Features & Use Cases

  • Read-Only Metadata Discovery: Use DAX INFO.VIEW.* and INFO.* functions to safely inventory semantic model objects including tables, columns, measures, relationships, hierarchies, and storage details without making any changes to the model.
  • Secure Data Retrieval: Execute ad-hoc DAX queries to pull aggregated or filtered data from the semantic model for analysis, reporting, or validation purposes.
  • Common Use Case: A data analyst can use this Skill to quickly document all business logic measures in a production sales semantic model, or pull year-over-year sales metrics by region for a stakeholder report without risking accidental model edits.

Quick Start

Use the powerbi-consumption-cli skill to first list all tables and columns in your Fabric workspace's 'Sales' semantic model, then run a DAX query to pull total sales grouped by product category for the previous quarter.

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 a Power BI semantic model in Fabric without modifying it?▼

To query a Power BI semantic model without modifying it, execute read-only DAX queries against your Fabric datasets. This approach allows you to retrieve aggregated data and discover metadata safely, ensuring no accidental model changes occur during analysis or reporting.

Can I use DAX to list all tables and measures in a Fabric semantic model?▼

Yes, you can use DAX to list all tables and measures in a Fabric semantic model. By leveraging DAX INFO.VIEW.* and INFO.* functions, you can safely inventory model objects including tables, columns, measures, and relationships for metadata discovery.

What do I need to run read-only DAX queries against Microsoft Fabric Power BI datasets?▼

To run read-only DAX queries against Microsoft Fabric Power BI datasets, you need access to the Fabric MCP server's ExecuteQuery tool and valid Fabric authentication tokens. Adhering to read-only guardrails ensures you avoid model-change operations during retrieval.

What is the best way to document business logic measures in a production Power BI semantic model?▼

The best way to document business logic measures in a production Power BI semantic model is by running read-only DAX metadata discovery queries. This allows you to safely extract and inventory measures without risking accidental edits to the live production model.

Are there limitations to querying Fabric Power BI datasets via read-only DAX?▼

A key limitation of querying Fabric Power BI datasets via read-only DAX is the strict adherence to read-only guardrails, which prevents any model-change operations. You can only extract data and discover metadata, meaning you cannot modify tables, relationships, or measures.

Related Skills

Explore More Data & Analytics Skills→
weiflycc-cmdweiflycc-cmd

powerbi-consumption-cli

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

Community
Intermediate
Datus-aiDatus-ai
1.5k

report-generator

Generate JSON, CSV, or markdown reports from SQL query results.

Official
Basic
weiflycc-cmdweiflycc-cmd

powerbi-authoring-cli

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

Community
Advanced
githubgithub
37.6k

powerbi-modeling

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

Official
Advanced