power-bi-partitions--expressions

# Power BI Partitions & Expressions Skill Manage table partitions, named expressions (M queries), and calendar tables. ## Prerequisites ```bash pipx install pbi-cli-tool pbi-cli skills install pbi connect ``` ## Partitions Partitions define how data is loaded into a table. Each table has at least one partition. ```bash # List partitions in a table pbi partition list --table Sales pbi --json partition list --table Sales # Create a partition with an M expression pbi partition create "Sales_2024" --table Sales \ --expression "let Source = Sql.Database(\"server\", \"db\"), Sales = Source{[Schema=\"dbo\",Item=\"Sales\"]}[Data], Filtered = Table.SelectRows(Sales, each [Year] = 2024) in Filtered" \ --mode Import # Create a partition with DirectQuery mode pbi partition create "Sales_Live" --table Sales --mode DirectQuery # Delete a partition pbi partition delete "Sales_Old" --table Sales # Refresh a specific partition pbi partition refresh "Sales_2024" --table Sales ``` ## Named Expressions Named expressions are shared M/Power Query definitions used as data sources or reusable query logic. ```bash # List all named expressions pbi expression list pbi --json expression list # Get a specific expression pbi expression get "ServerURL" pbi --json expression get "ServerURL" # Create a named expression (M query) pbi expression create "ServerURL" \ --expression '"https://api.example.com/data"' \ --description "API endpoint for data refresh" # Create a parameterized dat...