You are building a Power BI reporting layer for a multi-tenant federal analytics environment. Different tenant users must only see rows tied to their assigned agency, program, or contract, and the same dataset is reused across multiple reports and apps. The main risk is accidental cross-tenant exposure caused by a bad model, a broken mapping table, or an incorrectly assigned workspace role.
How would you implement and test Row-Level Security for a multi-tenant federal Power BI workspace?
You are building a Power BI reporting layer for a multi-tenant federal analytics environment. Different tenant users must only see rows tied to their assigned agency, program, or contract, and the same dataset is reused across multiple reports and apps. The main risk is accidental cross-tenant exposure caused by a bad model, a broken mapping table, or an incorrectly assigned workspace role.
How would you implement and test Row-Level Security for a multi-tenant federal Power BI workspace?