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).
- otravers
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
Hi otravers
I have an issue with RLS, when I combine a Power BI Dataset with data from Excel in a new dataset. RLS from the first seems to be in conflict with the new RLS. The table which needs RLS in the new dataset is connected to a table with RLS in the Power BI Dataset. Works fine in PBI Desktop, but not in Service. Do you know how I can solve this?
