Forum Discussion
Ignore RLS for huge dataset
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.
lbendlin could you elaborate more?
- connect to the sematic model
do you mean to create new semantic model that is not hosted in PBI? We are using postgresql and import data and we haven't worked on another hosting solution
- force a connection change to Direct Query
this one could be and option, I've heard that it's not easy to setup directquery for our postgres but i will try
- remove the RLS reference table from the data model
What do you mean? RLS refence table you mean Dim country?
- connect to the sematic model
- force a connection change to Direct Query
This is done with the above semantic model, not with your original source
- remove the RLS reference table from the data model
yes, whichever table holds your RLS rules