Forum Discussion

Icon for Impactful Individual rank

Impactful Individual

6 years ago

RLS produces bad performance

Hi guys, I'm experiencing performance issues in the bi when I applied the RLS to the report. As an example i have 3 tables: 1. Daily values of sales, estimations, etc per market (million of rows...

Icon for Most Valuable Professional rank

Most Valuable Professional

6 years ago

I think the problem is your RLS DAX, which has to filter the UserId from the column with the concantinated UserIds.

Could you share your RLS DAX or a sample pbix?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

dobregon
Impactful Individual
6 years ago
hi mwegener ,

I was looking some weeks about a solutions and i have re done my RLS in order to be more simple that i had month ago. Now i have the question if exists the posibility to check the query of a visual (i know in the performance analyser) but i need to know the memory that the query produces in order to can check the problem.

As i can see, when i use without RLS in the powerbi service normally i dont receive any error in the visuals but when i use RLS some visuals (the biggest visuals) produces the memory problem. With that analysis i will be able to know if the RLS is possible for me or not becasue my dataset of values is very big.
- mwegener
  Most Valuable Professional
  6 years ago
  Try DAX Studio
  https://daxstudio.org
  - dobregon
    Impactful Individual
    6 years ago
    i'm trying with DAX Studio and Tabular Editor but they dont give me the KB that a visuals produces; the only way is to checking the Task manager from windows but it is not a correct way to know the RAM memory that bi uses when i refresh a visual. In addition with that i cant compare with and without RLS becasue the memory problem appears when i acctive the RLS

Related content