Forum Discussion

lherbert501's avatar
lherbert501
Post Prodigy
8 months ago
Solved

Power BI Portal - RLS

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...
Show and Tell
  • Shai_Karmani's avatar
    Shai_Karmani
    8 months ago

    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



Shai_Karmani's avatar
Shai_Karmani
Super User
8 months ago

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's avatar
lherbert501
Post Prodigy
8 months ago

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's avatar
    Shai_Karmani
    Super User
    8 months ago

    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