Forum Discussion
PBI Row Level Security and State-wide view
My app shows the state-wide data if a Ministry of Health (MOH) user is logged in and only the relevant Local Health District's (LHD) data if an LHD user is logged in. See the screen shots below. MOH...
Hi IzakVA ,
We need to prepare a separate table of state-wide data. There is no model relationship between this table and other tables.
Places the District column of the state-wide table on the table visual object.
New roles.
View as:
If anything is unclear to you, please refer to my pbix file.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your quick reply. I don't think this will work for me, since I have a data model with many tables and 21 report pages with visuals that all need to work off the slicers. I can't duplicate the whole data model. Thanks for the suggestion.