Forum Discussion
Generate Power BI report user specific on website
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
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.
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.
5 Replies
Use row level security to achieve this.
you can find numerous tutorial on RSL .
https://analyticpulse.blogspot.com
If the user logging in does not have a Power BI account, will the RSL work?
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.
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.
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.
