Apply RLS to Power Query (M)

[rolf1994]

Hello,

I would like to know if it is possible to filter data before the data is loaded into the report based on criteria of the logged on user. I know we can achieve this by using RLS but this is not an option for us because when using RLS the report loads all the data in first before it starts to filter. We are using DirectQuery and the performance of the report while using RLS is really bad. We want to improve performance by defining our filters in the query based on the user that is logged on, instead of using RLS. Would this be possible in some way?

Thanks

[RMK]

I'm looking for same solution.  All alternatives are a pain.  SPSS allows loading of select records (e.g., rows 1 to 1,000), and then you can filter into required files by filter category....but this is two steps.  SPSS can handle large databases. 

RMK

[KumarDarmesh]

AFAIK, it is not possible. For performance, maybe use import mode.