PowerBI report authentification - web report with multiple unique users

[MarioBinas]

Hi,

kindly please could you help me to find the best way how the handle the following task?

We will create and build a PowerBI dashboard published on a public website. 

The report will be for more than 100 unique users, so the data must be filtered exactly based on the used licence key or other unique authentification.  This 100 users are independed entities and must see only data valid for them.

Kidnly, please could you help me to find the best way how to handle it? We can use the PowerBI Pro licences or the Premium (not sure how to secure the unique data visualisation via Premium). 

Thank you,

Mario

[v-chenwuz-msft · Accepted solution]

Hi @MarioBinas ,

You can use embed content for customers with RLS.

First, create a dataset with RLS. (Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles)

Second, Embed for your customers. embed a report which dataset contains rls roles. This won't ask the user login power bi ropert by your own authentication method rather than power bi acount.

How to Embed content in your Power BI.

When login your app, the app ask Azure AD to generate the embed token. Users are authenticated and authorized by your application and embed tokens are used to grant a user access to a specific Power BI Embedded report. Power BI Embedded doesn't have any specific information on who your user is. For RLS to work, you need to pass some additional context as part of your embed token in the form of identities. You can pass the identities by using the Embed Token API.

Using row-level security with embedded content in Power BI embedded analytics - Power BI | Microsoft...

After all of this is done, the user will log in and perhaps the corresponding data will be available according to the rules you set. That is, different report contents will be displayed according to different users.

For more details, you can refer this link.

Generate an embed token in Power BI embedded analytics - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.