Forum Discussion
PBI Row Level Security and State-wide view
Hi IzakVA ,
It sounds like you have solved the problem yourself. Do you mean you want LHD users to view the statewide view? Then you could create a table with just one column of statewide regions and then create a table visual object. Note that this table has no model relationship to any other table and does not have any RLS set up. you should only see the CCLHD slicer and the statewide area reference table when you select it for the CCLHD role.
If I have misunderstood you, please clarify in a follow-up reply.
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.
Hi Neeko Anonymous
Yes, I would like to have the LHD user view the state-wide data view and have only the Relevant LHD name available in the LHD slicer as a filter option. If the LHD is selected, only the LHD's data should be displayed. If unselected, the state-wide data should be displayed. Is this possible?
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.