Skill UI

A comprehensive guide for authors and developers on managing, writing, and validating Power Query M expressions within semantic model partitions. Covers critical concepts such as Query Folding for performance optimization, best practices for filtering and type handling, and advanced techniques for testing M code using the Power Query API.

This skill converts vague business questions or monitoring needs into a complete, structured, and implementation-ready dashboard specification. It guides users to define key metrics (KPIs), chart types, axes, filters, and optimal layout, providing data engineers and BI developers with all necessary details to build the dashboard without ambiguity.