Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
mericdav87
Frequent Visitor

Embed Power BI Report with RLS into Power Pages (Portal App) using Pro Licenses

We are creating a Power Page (Portal) for our customers to securely access a Power BI Report. The Power BI report must have RLS enabled to ensure that correct data is filtered. We would like to understand the best way of achieving this. One approach is to invite guest users (external) into Active Directory, and assign a Power BI Pro license to each user. Once this is done, we would look to share the Report on the Power BI service with these guest users so that they are provided access. However, when testing this method and Embedding the report code into the PowerPage as per the link below, the RLS roles set in the Power BI report do not seem to be carried into the Power Page. Does anyone have experience with this please? Thanks in advance

 

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-embed-secure#how-to-embed-power...

 

 

1 ACCEPTED SOLUTION
otravers
Community Champion
Community Champion

I tested this about six months ago and it worked well. Let's break down the issue into smaller parts by focusing first on the Power BI side. Are you able to successfully test your RLS rules for these AAD B2B guests in the Power BI service? Did you make sure they're only Viewers in the workspace where the report is hosted?

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

View solution in original post

3 REPLIES 3
sonali_23
Regular Visitor

Hey @mericdav87 
Did you find any way for it ?

mericdav87
Frequent Visitor

Hi otravers - apologies, I somehow missed this response at the time.

Yes we followed the steps above and managed to successfully implement RLS. Our main challenge now is to avoid double sign in from a user experience perspective. Currently the user needs to sign into the Power Page website using guest user credentials, and then once navigated to the Power BI Dashboard page sign into Power BI for the report to render - is there any way of avoiding this do you know please? 

 

thanks in advance

otravers
Community Champion
Community Champion

I tested this about six months ago and it worked well. Let's break down the issue into smaller parts by focusing first on the Power BI side. Are you able to successfully test your RLS rules for these AAD B2B guests in the Power BI service? Did you make sure they're only Viewers in the workspace where the report is hosted?

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!