skills.rest
Umbral-Bot
Umbral-BotOFFICIAL
Explore all skills by this author →
GitHub

power-bi

Design Power BI reports with DAX measures, Power Query transformations, and REST API integrations.

Updated Feb 26, 2026
Search Tags:#data modeling#reporting#business intelligence#dax#power bi#power query
One-click install
npx skills add https://github.com/Umbral-Bot/umbral-agent-stack --skill power-bi-umbral-bot
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: power-bi
Source: https://github.com/Umbral-Bot/umbral-agent-stack/tree/main/openclaw/workspace-templates/skills/power-bi
Command: npx skills add https://github.com/Umbral-Bot/umbral-agent-stack --skill power-bi-umbral-bot

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill empowers users to design robust Power BI reports, create complex DAX measures, and perform intricate data transformations using Power Query (M), enabling advanced data analytics and business intelligence.

Core Features & Use Cases

  • DAX Measures: Develop dynamic calculations for KPIs, trends, and complex business logic.
  • Power Query (M): Clean, transform, and shape data from various sources for optimal modeling.
  • Report Design: Structure and visualize data effectively for insightful dashboards.
  • API Integration: Leverage Power BI REST APIs for automation and embedding.
  • Use Case: Create a sales performance dashboard that tracks Year-over-Year growth, regional performance, and product category contributions, automatically refreshing data from multiple sources.

Quick Start

Use the power-bi skill to create a DAX measure that calculates the Year-over-Year sales growth.

Frequently Asked Questions about power-bi

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

FAQPage Schema
How do I create DAX measures for Year-over-Year sales growth in Power BI?▼

DAX measures for Year-over-Year sales growth in Power BI are created by developing dynamic calculations that track KPIs and business logic. This Skill designs these measures to calculate trends and regional performance automatically.

Can I use Power Query to clean and transform data from multiple sources for Power BI?▼

Power Query (M) is used to clean, transform, and shape data from various sources for Power BI. This Skill performs intricate data transformations to prepare and model your data optimally for reporting.

What is the best way to automate Power BI dataset refreshes?▼

Automating Power BI dataset refreshes is best achieved by leveraging Power BI REST APIs. This Skill designs API integrations to automate dataset refreshes and enable data embedding for business intelligence.

Does this approach support building KPIs and semantic models for business intelligence?▼

Building KPIs and semantic models for business intelligence is fully supported. This Skill designs Power BI reports and semantic models using DAX and Power Query to structure and visualize data effectively.

How do I structure a Power BI dashboard to visualize regional performance and category contributions?▼

Structuring a Power BI dashboard to visualize regional performance involves designing insightful reports that track data effectively. This Skill structures your data to visualize category contributions and performance trends.

When do I need Power Query transformations versus DAX measures in a semantic model?▼

Power Query transformations are needed to clean and shape data before loading, while DAX measures handle dynamic calculations and KPIs post-load. This Skill uses both to build robust semantic models for analytics.

Related Skills

Explore More Data & Analytics Skills→
jesseotremblayjesseotremblay
1

processing-data

Transform, clean, and extract structured information from CSV and JSON data.

Community
Basic
tippyentertainmenttippyentertainment

power-bi-developer

Develop Power BI reports, data models, and deployment pipelines with RLS.

Community
Advanced
GabeujinGabeujin

powerbi-modeling

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

Community
Advanced
JNZader-VaultJNZader-Vault

powerbi

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

Official
Advanced