Forum Discussion

Cyferki's avatar
Cyferki
Frequent Visitor
1 year ago
Solved

Ignore RLS for huge dataset

Hello, I have Premium License P2. In my scenario we have 20gb dataset with RLS. Basicly every country has it's own role plus one global role for managers. I need to build new report based on this ...
Need Help
  • Vinay_eshwara's avatar
    Vinay_eshwara
    1 year ago

    Hi Cyferki ,
    The solution of lbendlin can work for your case , but if you dont want to change the connection to Direct query you can try creating DAX measures to remove RLS.
    Steps:
    You can first use live connection to import semantic model(data set) from power bi service
    Now you can create a DAX measure like below,
    TotalSales_AllCountries = CALCULATE([TotalSales], REMOVEFILTERS('Country')).
    This will remove filters on country table and calculates total sales .
    Now you can publish the report again to the service without RLS.

    Alternate Solution:
    There is another solution where you can create PAGINATED REPORTS (since you have P2 license) which you can use to bypass RLS and other filters. If you are interested in this solution please reach out.

    Hope the above solutions work for you.If it does please Kudos and accept as solution.
    Thanks,
    Vinay.

Vinay_eshwara's avatar
Vinay_eshwara
Frequent Visitor
1 year ago

Hi Cyferki ,
The solution of lbendlin can work for your case , but if you dont want to change the connection to Direct query you can try creating DAX measures to remove RLS.
Steps:
You can first use live connection to import semantic model(data set) from power bi service
Now you can create a DAX measure like below,
TotalSales_AllCountries = CALCULATE([TotalSales], REMOVEFILTERS('Country')).
This will remove filters on country table and calculates total sales .
Now you can publish the report again to the service without RLS.

Alternate Solution:
There is another solution where you can create PAGINATED REPORTS (since you have P2 license) which you can use to bypass RLS and other filters. If you are interested in this solution please reach out.

Hope the above solutions work for you.If it does please Kudos and accept as solution.
Thanks,
Vinay.