Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I have a Power BI dataset on which I have put row level security in place on a 'Region' field. This works fine in this report, but I have another user who has used this dataset as the foundation for their report. My expectation was that this 'secondary' report would inherit the row level security of the parent dataset, but this doesn't seem to be the case. When a user from one of the restricted regions tries to access the secondary report, no data is shown, rather than just the data they should have access to.
Does anyone have any ideas?
Many thanks.
RLS is inherited. Maybe you have forgot to give access to the parent dataset.
RLS is indeed inherited from parent datasets to their Live Connection children. It's hard to say what's going on there, I'd doublecheck the RLS DAX expressions and build a troubleshooting report page that I'd put both in the parent and children reports to try and pin down what's going on using simple visuals.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.