Overlay notification/message (box and text) when access restricted page.

[NickzNickz_BI]

Hi...

I have created two (2) page. Page1 is Glossary and Page2 is Technical.

User1 can only access Page1 and User2 can access both pages.

1. My ideas is... when User1 login and access Page2, message will popup " You do not have access to this page, Please contact the administrator... ". (overlay - box and text).

2. Can we do it without use button to navigate us to the Page2. What i mean is, we use default tab instead of hide page when publish it in the power bi service (web) - workspace/apps... 

 

Regards,

NickzNickz

[rajendraongole1]

Hi @NickzNickz_BI - Instead of hiding the page entirely you can set a pop-up message using a conditional visual layer on Page 2 for User1. Use a DAX measure or filter based on the logged-in user to conditionally display a full-screen text box.In Power BI Service, this would show the message to User1 if they attempt to access Page 2. For User2, the page will behave normally, and they can view the technical content.

eg: AccessMessage = IF(USERPRINCIPALNAME() = "user1@domain.com", "You do not have access to this page, please contact the administrator.", "")

or using bookmarks and buttons to create custom navigation between pages. This approach allows for better control over what each user sees. When publishing to Power BI Service, you can also hide or control page navigation based on roles by managing the visibility of navigation buttons.

Hope this information helpsin your implementation.

[NickzNickz_BI]

Hi @rajendraongole1 ,

Yes ... that is what I'm looking for and I need to create/have a table with user information right? ... 

I plan to have a Box with deem color black (50% transparent) and notification text on top of it .... 

And this is measeure I need to use >

AccessMessage = IF(USERPRINCIPALNAME() = "user1@domain.com", "You do not have access to this page, please contact the administrator.", "")

Appreciate if you can give me the steps I need.... Regards,

NickzNickz

[rajendraongole1]

Hi @NickzNickz_BI -

Create a User Table:

In your Power BI model, create a table that lists the users and their respective permissions.
Example table (UserPermissions):
User CanAccessTechnicalPage
user1@domain.com 0
user2@domain.com 1
This table assigns 1 for users who can access the Technical page and 0 for those who cannot.

Create a Measure to Show the Access Restriction Message:

Create a DAX measure to check the logged-in user and their permission to access the page.
Example DAX measure:
DAX
Copy code
AccessMessage =
VAR CurrentUser = USERPRINCIPALNAME()
VAR HasAccess = LOOKUPVALUE(UserPermissions[CanAccessTechnicalPage], UserPermissions[User], CurrentUser)
RETURN IF(HasAccess = 0, "You do not have access to this page, please contact the administrator.", "")
This measure checks if the current user has access to the Technical page. If not, it displays the custom message.

Add the Overlay for Restricted Users:

Go to Page2 (Technical Page) in Power BI, and add a Shape or Box that covers the entire page.
Set the transparency to 50% and choose a black background for the box.
On top of the box, add a Text Box for the restriction message, and link it to the AccessMessage measure created earlier.
Hide or Show the Overlay Based on User:

Use the Conditional Formatting feature to control the visibility of the overlay.
For example, you can create a card visual with the AccessMessage measure and apply conditional formatting to show the overlay only when the message is not blank.
Deploying in Power BI Service:

After creating your report, publish it to Power BI Service.
Ensure that Row-Level Security (RLS) is configured correctly to restrict access based on the user permissions set in the UserPermissions table.
Use USERPRINCIPALNAME() to check who is logged in and conditionally control access to the page without using buttons or hiding the page.

[NickzNickz_BI]

Hi @rajendraongole1 ,

Result unsuccesfully or you can provide me any pbix file so that i can compare with mine...  😂 .... 

Regards,

NickzNickz