Forum Discussion

ArjanFraaij's avatar
ArjanFraaij
Frequent Visitor
6 years ago

RLS and full data compare graphs

Hi,

I created a report that shows buget against declarable.

Users that open Power BI should only see the Budget & Declarable for them selfs and should not be able to select an other user to see the budget & declarable figures they have as a user.

 

Only A single user should be able to see there own figures in a graph and the figures of the entire company  in an other graph.

 

Only RLS already filters data on highest level.

 

My current solution is that I also duplicated the Dataset (Fact) tables without the relation to the Lookups like "Medewerker" where the RLS is based on. And ofcource created measures on those datasets like TotalBudget based on the dataset table joined with the RLS structure & TotalBudget_NoRLS joined with the dataset table without relation to the RLS structure.

 

And this works but I wonder or there are other more simple solutions.

It should be something like creating the TotalBudget_NorLRS measure but make it ignore the RLS security. I tried using ALL for the medewerker filter already but that doesn't seem to do the trick.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    If I understand your situation correctly, in these situations I generally create a summary table that is disconnected from anything that RLS would impact using something like SUMMARIZE to create a new table in the data model. Then I tie summary visualizations that everyone should see to that table. 

    • ArjanFraaij's avatar
      ArjanFraaij
      Frequent Visitor

      Hi Greg,

       

      Thats the solution I now also handled. 
      I'm wondering or there is an other way arround.

       

      Regards.

      Arjan

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        I haven't found one. If you do, let me know!! 🙂