skills.rest
marcelodfelman
marcelodfelmanCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

Power BI Partitions & Expressions

Manage Power BI table partitions, M expressions, and calendar configurations via pbi-cli.

Updated Apr 17, 2026
Search Tags:#data sources#power bi#power query#partitions#incremental refresh#m expressions#calendar tables
One-click install
npx skills add https://github.com/marcelodfelman/pbi-skills --skill power-bi-partitions-expressions
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Power BI Partitions & Expressions
Source: https://github.com/marcelodfelman/pbi-skills/tree/main/power-bi-partitions
Command: npx skills add https://github.com/marcelodfelman/pbi-skills --skill power-bi-partitions-expressions

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps Power BI users manage complex data loading configurations by simplifying partition management, Power Query expressions, and calendar table setup.

Core Features & Use Cases

  • Partition Management: Create, list, refresh, and delete table partitions to support incremental refresh and efficient data loading.
  • Expression Configuration: Manage reusable M/Power Query named expressions for shared data sources, parameters, and connection settings.
  • Calendar Table Setup: Configure date tables for time intelligence scenarios and validate Power Query data generation patterns.

Quick Start

Use the Power BI Partitions & Expressions skill to configure incremental refresh partitions and manage shared Power Query data source expressions in my model.

Frequently Asked Questions about Power BI Partitions & Expressions

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

FAQPage Schema
How do I configure incremental refresh partitions in Power BI?▼

Configure incremental refresh partitions by managing table partitions through pbi-cli operations. This Skill creates, lists, refreshes, and deletes partitions to optimize data loading workflows and automate JSON-based model updates.

What is the best way to manage shared Power Query M expressions across data sources?▼

Manage shared Power Query M expressions by configuring reusable named expressions for parameters and connection settings. This centralizes data source control and streamlines expression management within your Power BI model.

How do I set up and mark a calendar table for Power BI time intelligence?▼

Set up calendar tables by configuring date table settings and validating Power Query data generation patterns. This ensures proper date configuration for accurate time intelligence calculations and reporting.

Can I automate Power BI partition creation and TMDL-based model workflows using pbi-cli?▼

Yes, automate partition creation and TMDL-based model workflows using pbi-cli operations. This Skill applies JSON automation to manage partitions, expressions, and table date configurations without manual interface intervention.

Do I need pbi-cli to manage Power BI table partitions and named expressions?▼

Yes, pbi-cli operations are required to execute partition creation, expression management, and calendar marking. This Skill relies on command-line automation to configure incremental refresh and TMDL-based model workflows.

Why are my Power Query data generation patterns failing during calendar table validation?▼

Calendar table validation fails when Power Query M expressions contain incorrect date generation patterns. This Skill validates data generation logic and configures table date settings to ensure proper time intelligence setup.

Related Skills

Explore More Data & Analytics Skills→
marcelodfelmanmarcelodfelman

Power BI Modeling

Build and manage Power BI semantic models with pbi-cli.

Community
Advanced
marcelodfelmanmarcelodfelman

Power BI DAX

Write, execute, and optimize DAX queries for Power BI semantic models.

Community
Advanced
Umbral-BotUmbral-Bot

power-bi

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

Official
Advanced
AradotsoAradotso
2

power-bi-agentic-development

Automate Power BI semantic models, PBIR reports, and Fabric deployments.

Official
Advanced