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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
VishrantiC
Regular Visitor

Embedded Power BI with RLS and show/hide visuals per user dynamically

Hello,

 

I have my website where I need my customers(external to my company) to able to see power-BI report without having access to Power-BI Service.

1st Question: I went through several videos in youtube and they says I need to provide embed token to get the report in my .net website. Will the users need power-bi service access for this? What are the steps I need to follow?

 

I need to provide customers restrictions by country and tabs.

Let's say there are total 7 tabs in the report.

1st one who is sitting in US should be able to see 4 tabs

2nd one who is sitting in US should be able to see all tabs

3rd one who is sitting in Canada should be able to see 3 tabs

4th one who is sitting in Germany should be able to see all tabs

5th one who is sitting in Canada should be able to see 6 tabs

6th one who is sitting in Canada should be able to see 2 tabs

 

2nd Question: I need to provide RLS in my embeded report based upon country and user rights. May be I can store those details in database(my database in Google Big query) table and provide RLS in Power-BI desktop. Can anyone tell me how I can dynamically do this exercise?

 

Your help would be really appreaciated, thanks in advance!

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @VishrantiC,

#1,In fact, current power bi embed features seems not able to be used fully exclude power bi service access. Accoding to your description, I think the ‘app owns data’ mode may suitable for your requirement:

Power BI embedded analytics overview - Power BI | Microsoft Learn

AFAIK, current report page visible seams not able to be dynamic change. I'd like to suggest you hide raw pages and create a custom navigation report page with different navigation buttons or bookmarks and show hide visual based on filter to achieve dynamic navigations.

Create page and bookmark navigators - Power BI | Microsoft Learn

Capture report views showcase | Microsoft Learn

Show or Hide a Power BI Visual Based on Selection  

#2, For power bi embedded report with RLS, you can refer to the following document to know more about these:

Security in Power BI embedded analytics - Power BI | Microsoft Learn

Using standard cloud based row-level security with embedded content in Power BI embedded analytics -...

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @VishrantiC,

#1,In fact, current power bi embed features seems not able to be used fully exclude power bi service access. Accoding to your description, I think the ‘app owns data’ mode may suitable for your requirement:

Power BI embedded analytics overview - Power BI | Microsoft Learn

AFAIK, current report page visible seams not able to be dynamic change. I'd like to suggest you hide raw pages and create a custom navigation report page with different navigation buttons or bookmarks and show hide visual based on filter to achieve dynamic navigations.

Create page and bookmark navigators - Power BI | Microsoft Learn

Capture report views showcase | Microsoft Learn

Show or Hide a Power BI Visual Based on Selection  

#2, For power bi embedded report with RLS, you can refer to the following document to know more about these:

Security in Power BI embedded analytics - Power BI | Microsoft Learn

Using standard cloud based row-level security with embedded content in Power BI embedded analytics -...

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hey @v-shex-msft , thank you so much for sharing the details, it's really explanatory.

I'm clear about #1 but hide and show pages would be bit complex in my scenario. I'm not sure how many customers are gonna view my site, the restrictions will be on country(plus customer rights e.g. Admin/user may be). Can you give me one example to elaborate more on this please?

 

Thanks in advance.

 

Regards,

Vishranti

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.