Forum Discussion
Generate Power BI report user specific on website
Hi All,
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?
How to approach this scenario
Hi vineetakande
It depends on how you've integrated Power BI into your web application. If you've used "Publish to web" (report is published to app.powerbi.com) you can't do this, "publish to web" gives anonymous access for all, even if your web access is behind your own password wall. Reports "Published to web" are on app.powerbi.com and accessible (and searchable) by anyone.
If you're using PowerBI embedded, or simply providing a link to the report on your web page you can do this.
So long as the viewers need to log in with a PowerBI account to see the Report, you can use Row Level Security (RLS) on the dataset the Report is based on.
This restricts the data Power BI users can see on a Report by login name. So you can create one report, share it with 10 other users and they will only see the data that is applicable to them.
Each user requires a Power BI licence, this needs to be Pro or Premium Per user if you only have a Pro or Premium Per User licence. It can be a Free licence if your organisation has a "Premium Capacity" licence.
You can find the microsoft documentation on RLS here Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
other useful links are here (53) What is Row-Level Security (RLS) in Power BI??? - YouTube
Hope this helps
Stuart
3 Replies
Hi vineetakande
It depends on how you've integrated Power BI into your web application. If you've used "Publish to web" (report is published to app.powerbi.com) you can't do this, "publish to web" gives anonymous access for all, even if your web access is behind your own password wall. Reports "Published to web" are on app.powerbi.com and accessible (and searchable) by anyone.
If you're using PowerBI embedded, or simply providing a link to the report on your web page you can do this.
So long as the viewers need to log in with a PowerBI account to see the Report, you can use Row Level Security (RLS) on the dataset the Report is based on.
This restricts the data Power BI users can see on a Report by login name. So you can create one report, share it with 10 other users and they will only see the data that is applicable to them.
Each user requires a Power BI licence, this needs to be Pro or Premium Per user if you only have a Pro or Premium Per User licence. It can be a Free licence if your organisation has a "Premium Capacity" licence.
You can find the microsoft documentation on RLS here Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
other useful links are here (53) What is Row-Level Security (RLS) in Power BI??? - YouTube
Hope this helps
Stuart
Hi vineetakande ,
I think Burningsuit explained it in more detail and can be used as a reference. If the question has been solved, you can mark it as the correct answer. If there is still confusion, please point it out and I will answer it for you as soon as possible!
Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.that was super relevant info .. thanks for that ..
