Forum Discussion

bhanu431's avatar
bhanu431
Frequent Visitor
8 years ago

RLS in PowerBI Service and in Embedding

As i am new to RLS topic in PowerBI i have few doubts about RLS:

I had developed PowerBI reports in PowerBI Desktop with PowerBI implemented on the Reports. 

My questions regarding RLS in powerBI Service are

1) Will RLS work in PowerBI Service(every user has different login id's)? How to implement RLS in Service??

2) Can we implement RLS on reports which i wanted to embed (by using link generated for report page in PowerBI service) in Sharepoint site.

 

Thanks

Bhanu

Need Help
Show and Tell

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi bhanu431,

     

    You can take a look at below links about RLS:

    Row-level security (RLS) with Power BI

    Row-level security (RLS) with Power BI Desktop

     

    Limitations

    Here is a list of the current limitations for row-level security on cloud models.

    • If you previously had roles/rules defined within the Power BI service, you will need to recreate them within Power BI Desktop.
    • You can define RLS only on the datasets created using Power BI Desktop client. If you want to enable RLS for datasets created with Excel, you will need to convert your files into PBIX files first. Learn more
    • Only ETL, and DirectQuery connections are supported. Live connections to Analysis Services are handled in the on-premises model.
    • Q&A and Cortana is not supported with RLS at this time. You will not see the Q&A input box for dashboards if all models have RLS configured. This is on the roadmap, but a timeline is not available.
    • External sharing is not currently supported with datasets that use RLS.
    • For any given model, the maximum number of Azure AD principals (i.e. individual users or security groups) that can be assigned to security roles is 1,000. To assign large numbers of users to roles, be sure to assign security groups, rather than individual users.

     

    >>2) Can we implement RLS on reports which i wanted to embed (by using link generated for report page in PowerBI service) in Sharepoint site.

    Please follow below steps to know how to embed power bi report to sharepoint.(RLS work for these embeded reports)

    Embed with report web part in SharePoint Online

     

    Regards,

    Xiaoxin Sheng