power-bi-modeling

Featured

Create and manage Power BI semantic model structure using pbi-cli -- tables, columns, measures, relationships, hierarchies, calculation groups, and date/calendar tables. Invoke this skill whenever the user says "create table", "add measure", "add column", "create relationship", "date table", "calendar table", "star schema", "mark as date table", "add hierarchy", "calculation group", or any model-building task. Also invoke when creating multiple measures at once -- the skill contains critical guidance on multi-line DAX expression handling.

AI & Automation 424 stars 111 forks Updated today MIT

Install

View on GitHub

Quality Score: 94/100

Stars 20%
88
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# Power BI Modeling Skill Use pbi-cli to manage semantic model structure. Requires `pipx install pbi-cli-tool`, `pbi-cli skills install`, and `pbi connect`. ## Prerequisites ```bash pipx install pbi-cli-tool pbi-cli skills install pbi connect ``` ## Tables ```bash pbi table list # List all tables pbi table get Sales # Get table details pbi table create Sales --mode Import # Create table pbi table delete OldTable # Delete table pbi table rename OldName NewName # Rename table pbi table refresh Sales --type Full # Refresh table data pbi table schema Sales # Get table schema pbi table mark-date Calendar --date-column Date # Mark as date table ``` ## Columns ```bash pbi column list --table Sales # List columns pbi column get Amount --table Sales # Get column details pbi column create Revenue --table Sales --data-type double --source-column Revenue # Data column pbi column create Profit --table Sales --expression "[Revenue]-[Cost]" # Calculated pbi column delete OldCol --table Sales # Delete column pbi column rename OldName NewName --table Sales # Rename column ``` ## Measures ```bash pbi measure list # List all measures pbi measure ...

Details

Author
MinaSaad1
Repository
MinaSaad1/pbi-cli
Created
4 months ago
Last Updated
today
Language
Python
License
MIT

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Listed

power-bi-modeling

Use for semantic model design, data source profiling, partition management, incremental refresh, calendar table generation, and locale/culture settings. Triggers on: "star schema", "dimensional model", "fact table", "dimension", "relationship", "calculated column", "pbi model", "pbi source", "pbi partition", "incremental refresh", "pbi calendar", "pbi culture", "scaffold", "cardinality", "many-to-many", "role-playing dimension", "source profiling", "M query". Do NOT trigger for DAX measure writing (→ power-bi-dax), report visuals (→ power-bi-report-design), or governance rules (→ power-bi-governance).

0 Updated today
mudassir09
Data & Documents Featured

power-bi-documentation

Auto-document Power BI semantic models by extracting metadata, generating documentation, and cataloging all model objects using pbi-cli. Invoke this skill whenever the user says "document this model", "what's in this model", "list everything", "data dictionary", "model inventory", "audit contents", "catalog", "describe the model", or wants to understand what objects exist in a semantic model.

424 Updated today
MinaSaad1
AI & Automation Featured

power-bi-deployment

Import and export TMDL/TMSL formats, manage model lifecycle with transactions, and version-control Power BI semantic models using pbi-cli. Invoke this skill whenever the user mentions "deploy", "export", "import", "TMDL", "TMSL", "version control", "git", "backup", "migrate", "transaction", "commit changes", "rollback", or wants to save/restore model state.

424 Updated today
MinaSaad1