Report performance with Row level security

Hi ani_informa,

I do not so recommend you to create 'one: one' mapping RLS for the ultra-large amount of records, it obviously will affect the performance due to duplicate records.

I searched for power bi relationship bi but not found documents that mentioned how to mapping rows without affect performance.
Since power bi data model stored data at AS instance, maybe you can take a look at AS tabular model RLS related document:

Optimizing RLS performance with the Query Store 

In addition, you can also consider creating a weak relationship mapping between user and store, then you can add filters and conditions in your RLS expression to help to map records more accurately.

Relationships in analysis services tabular models  

Regards,

Xiaoxin Sheng