Forum Discussion
Generate Power BI report user specific on website
- 4 years ago
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
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