Forum Discussion
Helper IIIUsing RLS with Datasets
RLS should be defined in the parent dataset, not in the Live Connection report. If memory serves you can't use the security settings RLS test functionality with Live Connection report, you'll have to test accessing the report with one of the RLS'd users (make sure they're a Viewer in the workspace).
Yep, you'll have to test RLS in the workspace, the Live Connection will inherit RLS rules from the parent dataset since they're part of the data model.
https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Helper IIII tried connecting the RLS Email Table directly to the PBIX file that contains the report (and all the visuals) and creating a relationship to one of the tables that has been brought in through Get Data > Power BI datasets and that did not work either. Again, the RLS does work in the pbix file containing the dataset with all the tables but will not work in the pbix containing the visuals with the connection to the pbi dataset.
Community ChampionRLS should be defined in the parent dataset, not in the Live Connection report. If memory serves you can't use the security settings RLS test functionality with Live Connection report, you'll have to test accessing the report with one of the RLS'd users (make sure they're a Viewer in the workspace).