Power BI Portal - RLS

[lherbert501]

Hi,

I want to be able to create some form of portal/app for external customers to log into and view their report/reports via RLS, against some custom log ins stored in a database.

Has anybody got any experience of this or any articles?

Thanks

Liam

[Shai_Karmani]

If you really want a custom portal with your own usernames stored in a database, look at Power BI Embedded, app-owns-data.
You can read a lot about it here
Your app authenticates users against your DB, then your backend generates an embed token and applies RLS based on their identity.
In that model customers do not need Power BI licenses, but you need a Fabric capacity.

Shai Karmani | Data & Analytics

If it helped  please mark as resolved & give a kudo so others can find it too.

Let’s connect on LinkedIn

[lherbert501]

Hi @Shai_Karmani 

Thanks for this. This is the route I would need I think.

I'm comfortable setting up the RLS and generating the token etc, but I can't find much online about displaying the app and with a log in.

Is there anything out there that I could use, being a non developer, that I could use to integrate the c# code e.g. power apps or wordpress? It has to go to external customers.

Thanks

[Shai_Karmani · Accepted solution]

Sure,

a non developer good realistic approach that I suggest is:

Power Pages (Microsoft native, for external customers)

Power Pages lets you build an external portal with login and then add a Power BI component to a page. You can use the “Embed for your customers” / Power BI Embedded path so that:

- External customers log in to your portal
- RLS is applied from your dataset
- They do not need individual Power BI licenses, as long as the workspace is on Premium or Fabric capacity

Good starting points from Microsoft:

- Add a Power BI component to a Power Pages site
https://learn.microsoft.com/en-us/power-pages/getting-started/add-power-bi

- How to: Embed Power BI in Power Pages (covers Embedded, RLS, filters etc)
https://learn.microsoft.com/en-us/power-pages/guidance/how-to-power-bi-embedded
Hope that helps, let me know if it seems it's somethin that can work for your use case.

Shai Karmani | Data & Analytics

If it helped  please mark as resolved & give a kudo so others can find it too.

Let’s connect on LinkedIn

[lherbert501]

@Shai_Karmani Would the below allow this to work? 

[lherbert501]

Thankyou @Shai_Karmani , this is really helpful

[amitchandak]

@lherbert501 , You can add your customer as an external/guest user, and then can give them access to the report using RLS. Make sure the viewer of the workspace and app. 

refer:https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/service-admin-entra-b2b
https://learn.microsoft.com/en-us/power-bi/consumer/mobile/mobile-apps-b2b