Failure RLS in Direct Query

[Anonymous]

Hi, in my report, I have set up a RLS for 3 levels (1.All markets  2.Specific market  3.special store)

RLS

All Market

All Market

Japan

Austrlia

Store1

Store2

I am having a big problem that for my report(Direct Query), it works fine when no RLS apply or even applying "All markets".

But it shows the below error when the RLS is specific market or shop

Please help.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can click on See details to view a dialogue box that explains more information. Both the dialogue box and Power BI documentation recommend filtering to decrease the amount of data displayed.

Or it may simply be more effective to alter DAX calculations so that they consume less memory. 

Refer to:

The “Visual Has Exceeded The Available Resources” Error In Power BI

Troubleshooting tile errors - Power BI | Microsoft Docs

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