Generate Power BI report user specific on website

[ajet_p-91]

I am having a problem in showing user-specific reports on my website for user-specific group

I have my database in SQL SERVER where I have cumulative data of all the users.

I have integrated Power BI into my Web Application to show reports.

Now I want to show report data specific to the person who has logged in but is unable to find it anyway.

Is there any way where I can send the dynamic data depending upon the person logged in to Power BI to generate the report?

( The user doesn't have a power bi account )

How to approach this scenario

[Anonymous · Accepted solution]

Hi @ajet_p-91 ,

If you want to share dynamic data with users, you can configure RLS. However, you need a Power BI account and a license.
For more information about how to set up RLS, please refer to the following documentation.

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

To apply for a Power BI account, please refer to the following documentation.

Self-service sign up for the Power BI service or Fabric as an individual - Power BI | Microsoft Lear...

Regarding the license requirements, if the creator of the report is a Pro or PPU license, the user must also be a Pro or PPU license. If the creator of the report has a Premium license, the user only needs to be a free user. Please refer to the documentation for more information.

Types of licenses for Power BI business users - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

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

[SaiTejaTalasila]

Hi,

You can apply RLS or you refer this-

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

I hope it will be helpful to create something with buttons.

[ajet_p-91]

If the user logging in does not have a Power BI account, will the RSL work?

[AnalyticPulse]

yes

[AnalyticPulse]

Use row level security to achieve this.

you can find numerous tutorial on RSL .

Learn Power BI free:

https://analyticpulse.blogspot.com

Power BI : getting started

Dax functions

powerbi Visualisation