James Tuck on 01 Oct 2019 20:46:32
Need "View as Role" on report with RLS on shared dataset. I have a dataset that is shared with multiple reports that reside within the same workspace, but I cannot test the reports with RLS on the desktop side nor on the web side. On the desktop side, the Manage Roles and the View as Roles are grayed out. On the web side, "Test as role" does not recognize the report associated with the dataset. I receive the error "Role testing in row-level security (RLS) currently requires a report. Please build a report with this dataset to use role testing." But this is the report that is associated with the dataset!
RLS works in this scenario but it cannot be tested. What gives?
- Comments (2)
RE: Testing RLS on shared dataset
Miles has right. But this isn't "oddly" important, but "really" important issue. It's necessary to be available to use RLS in reports that use Live Connection to Power BI Datasets which have RLS configured. Please, do something about it!
RE: Testing RLS on shared dataset
This is oddly important. Often times we need to validate RLS on the LiveConnect reports. OR for training purposes we need to demonstrate the LiveConnect report via a specific role that the audience will have.
Would love to be able to choose Test as Role on the original dataset and then have the ability to select any connected report to test the role with.