Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

RLS on Report Server KPI

I did created a kpi in report server using SSAS cube as my data source. And Roles are aleady defined in that cube and it is working fine for each users for power bi reports.   First, I did created...
Report Server KPI
RLS
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for the reply Anonymous,

But this is not about Report level RLS.

 

We can create KPI's using Report Builder by creating some shared/embedd datasets in report server.

 

For those KPI's and Paginated reports, how we can implement RLS.

 

Any help.

 

 

 

  • adrez86's avatar
    adrez86
    Helper I
    7 years ago

    I believe Report Server only supports RLS on Power BI reports right now. If you're using a live connection through your SSAS datasource then this may help you setup RLS on SSAS side

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for the reply adrez86.

       

      FYI, i did these things already, and i have successfully published more than 50 reports till now in my organization.

      But I am trying to make dashboard kind of user experience(Like in powerbi service) in report server by creating these KPI's and paginated report visuals.

       

      So, thats the reason im trying to get implement RLS for these KPI and all.

       

      I didnt understood one thing, that, whats the use of giving KPI as an option if ther's not proper RLS is not applied to these.

       

      Just asking.

       

      Any help.

       

      • adrez86's avatar
        adrez86
        Helper I
        7 years ago

        Power BI reports didnt have proper RLS until last week so would you ask why would they give us Power BI reports without proper RLS? They're always adding new things.

         

        You can suggest new ideas here