Much slower (10x) with Row Level Security

[Anonymous]

We have a report that is quick without RLS and 10x slow with it

Is there any known issue we should look at?

[v-alq-msft]

Hi, @Anonymous 

I have two questions:

1. Which data sources are you using?

2. Are you using import mode or DirectQuery mode?

If you are using Import mode, then it will run the query on the Imported data. If you are using DirectQuery, it will send a query to the underlying data source when a user opens or interacts with a report. It depends on the performance of the data source.

For further information, you may refer to the document .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @v-alq-msft - thanks for writing, I appreciate you taking the time

We found that in Composite mode, performance was incredibly slow (60 seconds) while in DirectQuery it was good enough (10x faster)