Forum Discussion
Dashboard
- 3 years ago
No to both.
- Rethink your requirements. Do you actually need a dashboard or can you direct your users to the report? That would be one less click
- Think about using RLS and OLS. These are the only safe methods to restrict access to data. Regardless of what you see on Youtube - there is no such thing as page level security.
- 3 years ago
Hi Anonymous ,
According to your description, here are my suggestions.
1, You can select “Hide Page” before publishing the report to service so that when users click the visual you pinned on the dashboard, users will just view the page the visual on.
2, If you want users to see the pages they can view in the report, you can use RLS.
Please note that RLS can only control rows, so you need to take the name of each page as a row for the permission table and then use navigation to jump to the corresponding page.
Create a “page permission” table and load it to the report. (Tabelle1 is a data table, Tabelle1(2) is a “page permission” table.)
Manage roles:
Create a cover:
You can create a cover to show the page permission of different users. Put “page permission” into slicer.
Create a measure:
page navigation = SELECTEDVALUE ( 'Tabelle1 (2)'[page permission] )Create a button as page navigation and use the measure as destination.
Finally, publish the report to service and add members of RLS, then when user open the report, they can only view pages they are allowed to.
Please refer to the following documents.
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
l would suggest creating a sketch as it seems like there are multiple pages invovled. So in order to keep a track, create a wireframe of the reports, you can use tools like mokkup.ai to do so. Probe further into the requirements with your wireframe and get a sign off on the wireframes. this will give you a clarity of the process.