power-query

npx skills add data-goblin/power-bi-agentic-development --skill power-query --agent claude-code

Same command for any agent — swap --agent for codex, cursor, copilot.

# Power Query for Semantic Models Author, validate, and test Power Query M expressions in semantic model import partitions. Covers writing correct M code, preserving query folding, validating expressions, and testing them by executing against real data sources. ## Partition Expressions Each import table in a semantic model has a partition with an M expression defining what data gets loaded during refresh. The expression typically connects to a data source, navigates to a table/view, and applies transformations. ### Structure of a Partition Expression ``` let Source = Sql.Database(#"SqlEndpoint", #"Database"), Data = Source{[Schema="dbo", Item="Orders"]}[Data], #"Removed Columns" = Table.RemoveColumns(Data, {"InternalId"}), #"Changed Type" = Table.TransformColumnTypes(#"Removed Columns", {{"Amount", Currency.Type}}) in #"Changed Type" ``` Key elements: - **Parameters**: `#"SqlEndpoint"`, `#"Database"` are shared M parameters defined at the model level - **Navigation**: `Source{[Schema="dbo", Item="Orders"]}[Data]` navigates to a specific table - **Steps**: Each step is a named variable in the `let...in` chain - **Quoted identifiers**: Step names with spaces use `#"Step Name"` syntax

Get partition expression from TMDL via fab
fab get "<Workspace>.Workspace/<Model>.SemanticModel" -f \
Get shared M parameters
shared SqlEndpoint = "myserver.database.windows.net";
shared Database = "MyDB";
shared Result = let
Source = Sql.Database(SqlEndpoint, Database),
Data = Table.FirstN(Source{[Schema="dbo",Item="Orders"]}[Data], 10)
in Data;'
curl -s -o result.bin -X POST ".../executeQuery" \