Forum Discussion

syasmin25's avatar
syasmin25
Icon for Helper V rankHelper V
4 years ago

PowerBI dataset redundancy

Hello, 

I have a report dataset with RLS set up for people based on their level of access. I am trying to create another report based on this but it would provide overall view for the whole organization and I did not want RLS to be implemented on this. Would it be possible? Or, would I need to duplicate the same dataset, remove RLS and and create the report based off of that?

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • npergand's avatar
    npergand
    Icon for Helper II rankHelper II
    4 years ago

    I would think you should be able to create another Role that does not have an RLS query associated with it (no filter). Assign the users who should have the full view to that role.

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi syasmin25 

    When you Implement RLS in your report it is like you have added a DAX query to be applied on the dataset, therefore when you use the same dataset to build a new report it is like starting from scratch on a new canvas and no query is applied on the dataset. so to answer your question "Would it be possible?" the answer is YES. No need to duplicate the same dataset.