Restrict Access to Report Page

[Atf23]

Hi,

I Have a report with multiple pages, I make some process to restrict access to those pages so that one user can access one page using a config file containing the user id and the page he can access. That works very well, however, I am afraid that if one user share the url of the page he can access to another user who is in the audience, the process I made will not be really effective ? 

Can we restrict accessing pages by urls using usernames so that if a user can effectively access a report but he is not allowed to see some page, he cannot view it ?

Thanks a lot for any help 🙂

[Atf23]

Thanks a lot, I'll try that 

[Anonymous · Accepted solution]

Hi,@Atf23 .
I am glad to help you.

According to your description, you are concerned that shared RULs may be bypassing user ID access restrictions.

I think you can try Row Level Security in Power BI to solve your problem, if you are not already using RLS.

RLS is a restriction on the dataset itself that is used for the report (if you have User ID columns in your data).

Let's say you have the following data in your original data set
Table1:
User ID                                               URL
jack@123.onmicrosoft.com                https://app.powerbi.com
(The above data are simulated)

You can restrict users from accessing data in a report by setting the RLS to only if the UserID of the user currently accessing the report exists in the original data will that user be able to see that row of data (including seeing the URL) in the visual (including seeing the URL).

By binding the User ID to the URL, you can restrict the user's ability to see the corresponding data.

If the UserID of the accessing user is not in the data, then the user will not be able to see the data.

I recommend you to use Dynamic RLS (use UserPrincipalName() to dynamically filter the data according to the user account of the accessing user).

Documentation on RLS settings
URL:
Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Learn
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

If you want to realize the blocking of URLs, I found a related issue that has been solved, I hope to help you!
Solved: How to mask a URL in PowerBI - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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