Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone:
I want to hide a page from view of some users, based on roles. To be clear, I don't mean "right-clicking the tab and hiding tab", unless this can be done circumstantially.
I have 2 identical pages generated: one with sensitive data and one without. I have already used RLS to obscure the sensitive data on the 2nd page from those who should not see it.
However, users are still able to view the page (albeit with blank columns) and it is causing confusion.
I'm looking for a creative solution to cover/obscure the contents of the page based on Roles - I was thinking of something to the effect of a Card visual or a Text Box that direct the user back to the appropriate page for their role. I'm unsure how to do this for roles; has anyone experienced a similar question?
Thanks!
Solved! Go to Solution.
You may leave a comment and vote this idea up.
Hide the page, then create a button for navigate to the page, then use RLS to hide or disable the button.
To do that you add a table to your data with a column which its row contain the name of your page. Then create a button and go to action, set it to page navigation, then instead of choosing a page go to function and choose the field which have the name of your page. At last go to manage role and district that field for desired roles so the button doesn't work for them. That's it.
Additionally you can use the same approach in text property to hide the name of page of you want, that way the button text for ones who doesn't access will be blank.
You should be able to get a COUNT of the restricted table and if it returns BLANK or 0 then you could have a measure display that text in a card visual versus otherwise, have that visual be blank.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |