Forum Discussion

saagarkinja's avatar
saagarkinja
Advocate II
10 years ago
Solved

Role Level Security using Power BI REST API

Dear All,

 

I have a quick question.

 

We are into implementing REST API for embedding Power BI Reports in SharePoint.

 

My question is,

    If above is implemented, will we get Role Level Security assuming the Power BI Reports are configured live with SSAS Tabular Model.

 

Please note, RLS is configured at SSAS end.

 

Every suggestion or solution is appreciated.

 

Thanks,

Saagar Kinja

As per me , it should Work :)  :smileyvery-happy:

  • saagarkinja

     

    It should work. Check Tutorial: Dynamic row level security with Analysis services tabular model

     

    Just note that there are a few considerations to keep in mind when working with row level security, SSAS and Power BI.

    1. On-premise row level security with Power BI is only available with Live Connection.

    2. Any changes in the data after processing the model would be immediately available for the users who are accessing the report is based on live connection from the Power BI service.

1 Reply

Replies have been turned off for this discussion
  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee

    saagarkinja

     

    It should work. Check Tutorial: Dynamic row level security with Analysis services tabular model

     

    Just note that there are a few considerations to keep in mind when working with row level security, SSAS and Power BI.

    1. On-premise row level security with Power BI is only available with Live Connection.

    2. Any changes in the data after processing the model would be immediately available for the users who are accessing the report is based on live connection from the Power BI service.