cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alâa
Frequent Visitor

Dashboard

Dear Community,

 

I hope you are doing well,

 

I have created a dashboard with visuals from a report.

Note that this report contains many pages.

 

Lately, I have shared my dashaboard to users.

I have noticed that some of them go to the report and look to other pages.

(When you push on a visual, you are redirected to the report)

Some of them contains confidantial data.

As you can imagine, I do not want them to see the other pages.
Also, I would like to keep all pages in the same report.

 

Do you think it is possible to manage page accesses to that users?

Or is it possible to desactivate that feature?

 

Kind Regards,

T.A.

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

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.

View solution in original post

v-xiaosun-msft
Community Support
Community Support

Hi @Alâa ,

 

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.

vxiaosunmsft_0-1664175851002.png

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.)

vxiaosunmsft_1-1664175851005.pngvxiaosunmsft_2-1664175851006.png

Manage roles:

vxiaosunmsft_3-1664175851008.png

Create a cover:

You can create a cover to show the page permission of different users. Put “page permission” into slicer.

vxiaosunmsft_4-1664175851009.png

Create a measure:

page navigation =
SELECTEDVALUE ( 'Tabelle1 (2)'[page permission] )

Create a button as page navigation and use the measure as destination.

vxiaosunmsft_5-1664175876167.png

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.

vxiaosunmsft_6-1664175876170.png

 

Please refer to the following documents.

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

 

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-xiaosun-msft
Community Support
Community Support

Hi @Alâa ,

 

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.

vxiaosunmsft_0-1664175851002.png

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.)

vxiaosunmsft_1-1664175851005.pngvxiaosunmsft_2-1664175851006.png

Manage roles:

vxiaosunmsft_3-1664175851008.png

Create a cover:

You can create a cover to show the page permission of different users. Put “page permission” into slicer.

vxiaosunmsft_4-1664175851009.png

Create a measure:

page navigation =
SELECTEDVALUE ( 'Tabelle1 (2)'[page permission] )

Create a button as page navigation and use the measure as destination.

vxiaosunmsft_5-1664175876167.png

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.

vxiaosunmsft_6-1664175876170.png

 

Please refer to the following documents.

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

 

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for you answers.

 

I had already thought about using RLS that way.
However, it is really poor when it comes to security and access.


Hiding pages is a really simple and interesting solution.

lbendlin
Super User
Super User

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.

Thank you for your answer.

Yes, rethinking the requirements is the best thing to do.
Either I will hide pages or I will split it into 2 reports.
This are the are the most simple way to deal with that.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Kudoed Authors