Forum Discussion

PelaezLink's avatar
PelaezLink
Helper I
3 years ago
Solved

RLS for external users without Power BI account.

Hello everyone.   I have a finsihed Power BI report and is it supposed to work as an app-dashboard thing. Basically we will distribute the report to nearly 300 users, each one should be able to vie...
  • TomMartens's avatar
    3 years ago

    Hey PelaezLink ,

     

    unfortunately, there is no simple answer.
    The only way to access Power BI content without any kind of authentication is the feature called "Publish to web", but this feature does not support Row Level Security. Please be aware that it is absolutely not recommended to create different reports, one report for a customer and publish these reports to the web. Everyone how has the url can access the report.
    Basically there are two solutions.

    1. Add users to your AAD
      This means users must be in your Azure AD for authentication, and also must have a license, as you ruled out Premium Per Capacity due to costs, users need to have a Pro license, either they can use their own, or you can assign one of your Pro licenses to these Azure Active Directory users.

    2. Create a Power BI embedded solution
      This requires that you create a web app "Embed for your customers" and do the user management from inside the app, this kind of solution requires you to buy a so called A-SKU.
      1. Power BI embedded analytics overview - Power BI | Microsoft Learn
      2. Pricing for A-SKU's: Pricing - Power BI Embedded | Microsoft Azure

    Hopefully, this helps to tackle your challenge.

     

    Regards,

    Tom