Build Tests via UI/Low-Code - DAX Query View

With the introduction of DAX Query View, building tests that are coupled with the Power BI files are a wonderful capability. However, writing DAX can be hard and may feel like a bridge too far to write DAX that tests your model. Why not have the DAX written for us by an interface that set checks like:

• Column Expectations -- Ability to use comparison operators (e.g., greater/less than, not null, regex, is in).
• Schema Expectations -- Ability to validate primary keys and the names and types of the tables.
• Content Expectations -- Ability to validate row counts with operators (e.g., greater/less than, equal, group by).
• Measure Expectation -- Ability to validate DAX measures under certain filters/conditions.

At present we must use tools like Performance Analyzer to generate DAX or Quick Queries in DAX Query View to generate statistics and copy those values. A smoother user experience would improve the adoption of testing.