Forum Discussion

vineetakande's avatar
vineetakande
Frequent Visitor
4 years ago
Solved

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 in...
  • Burningsuit's avatar
    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