rls_test_harness
Evaluate a DAX query against every role in a Power BI model plus an unfiltered baseline to reveal silent row-level security gaps where roles return identical row counts.
Instructions
Prove the model's security filters: evaluate one DAX query under EVERY role in the model plus an unfiltered baseline, returning a per-role matrix of {role, rowCount, sampleRows, error}. A role whose rowCount equals the baseline is not filtering that query - the classic silent-RLS-gap detector. Read-only.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | the DAX query to evaluate per role (bare table expressions get EVALUATE prefixed) | |
| sessionId | Yes | ||
| sampleRows | No | sample rows to return per role (default 5, max 100; rowCount is always the full count) |