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

[VishrantiC]

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!

[v-shex-msft · Accepted solution]

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

[VishrantiC]

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